A premium website is more than an online brochure. It is your digital office, sales representative, customer support desk, brand proof and search engine asset working every day.
For businesses in Ghana and beyond, customers compare brands online before calling. A strong website improves trust, captures leads, supports payments, and gives your brand a professional foundation.
Tettevi Group builds websites with responsive layouts, SEO-ready structure, fast loading pages, and clean user journeys that help visitors take action.
',NULL,'published',1,'Why Every Business Needs a Premium Website in 2026','Premium website benefits for modern businesses',NOW()), ((SELECT id FROM blog_categories WHERE slug='real-estate' LIMIT 1),(SELECT id FROM users WHERE email='admin@tettevigroup.com' LIMIT 1),'Property Investment Guide for Accra Buyers','property-investment-accra-guide','Key things buyers should know before investing in Accra real estate.','Accra remains one of Ghana’s strongest real estate markets, but smart investors need clear goals, proper documentation checks, and professional guidance.
Before buying, confirm land title, location growth potential, road access, rental demand, and total ownership cost. A good investment is not only about price; it is about security, long-term demand, and exit options.
Tettevi Group supports buyers with property sourcing, due diligence guidance, negotiation support, and investment advisory.
',NULL,'published',1,'Property Investment Guide for Accra Buyers','Real estate investment guide for Accra buyers',NOW()), ((SELECT id FROM blog_categories WHERE slug='travel' LIMIT 1),(SELECT id FROM users WHERE email='admin@tettevigroup.com' LIMIT 1),'Stress-Free Travel Planning for Families and Businesses','stress-free-travel-planning','How professional travel planning saves time, cost and stress.','Travel becomes easier when flights, accommodation, documents, transport, and itinerary details are coordinated early.
Families need convenience and safety. Businesses need reliability, cost control and proper records. With professional planning, travellers avoid last-minute pressure and enjoy smoother trips.
Tettevi Group helps clients plan tours, flights, logistics and travel experiences with care and attention to detail.
',NULL,'published',1,'Stress-Free Travel Planning','Professional travel planning tips',NOW()); INSERT IGNORE INTO `portfolio_projects` (`category_id`,`title`,`slug`,`client`,`description`,`featured_image`,`gallery`,`technologies`,`results`,`project_url`,`is_featured`,`completed_at`,`meta_title`,`meta_description`) VALUES ((SELECT id FROM portfolio_categories WHERE slug='it-solutions' LIMIT 1),'Premium E-Commerce Platform','ecommerce-platform','Retail Ghana Ltd','A complete e-commerce platform with product catalogue, cart, checkout, payment integration and admin order management.',NULL,JSON_ARRAY(),JSON_ARRAY('PHP 8','MySQL','Paystack','Responsive UI','Admin Dashboard'),JSON_ARRAY('Improved digital sales workflow','Reduced manual order handling','Created mobile-first shopping experience'),NULL,1,CURDATE(),'Premium E-Commerce Platform','Portfolio detail for e-commerce platform'), ((SELECT id FROM portfolio_categories WHERE slug='branding' LIMIT 1),'Corporate Brand Identity System','corporate-brand-identity-system','Tettevi Group Client','A full visual identity project including logo direction, color system, typography, marketing templates and brand launch assets.',NULL,JSON_ARRAY(),JSON_ARRAY('Brand Strategy','Graphic Design','Social Media Kits','Print Assets'),JSON_ARRAY('Consistent brand presence','Professional launch materials','Improved customer trust'),NULL,1,CURDATE(),'Corporate Brand Identity System','Branding portfolio project'), ((SELECT id FROM portfolio_categories WHERE slug='real-estate' LIMIT 1),'Real Estate Listing Portal','property-portal','Zuri Estate','A property listing and lead capture portal for real estate buyers, sellers and investors.',NULL,JSON_ARRAY(),JSON_ARRAY('PHP','MySQL','Property Search','Lead Forms'),JSON_ARRAY('Better property discovery','More qualified enquiries','Responsive buyer experience'),NULL,1,CURDATE(),'Real Estate Listing Portal','Real estate portal portfolio project'); INSERT IGNORE INTO `properties` (`title`,`slug`,`type`,`property_type`,`price`,`currency`,`bedrooms`,`bathrooms`,`area_sqft`,`location`,`city`,`region`,`description`,`features`,`featured_image`,`gallery`,`is_featured`,`status`) VALUES ('4-Bedroom Executive Villa','east-legon-villa','sale','villa',850000.00,'GHS',4,3,3444.00,'East Legon, Accra','Accra','Greater Accra','A stunning executive villa in one of Accra’s most desirable residential areas with spacious interiors and premium finishing.',JSON_ARRAY('Fitted Kitchen','CCTV Security','Double Garage','Backup Generator','Air Conditioning','Garden'),NULL,JSON_ARRAY(),1,'available'), ('Trasacco Estate Luxury Home','trasacco-luxury','sale','villa',1200000.00,'GHS',5,4,5597.00,'Trasacco, Accra','Accra','Greater Accra','An exceptional luxury residence within a secure gated estate, designed for comfort, privacy and high-end living.',JSON_ARRAY('Swimming Pool','Smart Home System','Home Theater','Solar Power','Staff Quarters','Landscaped Garden'),NULL,JSON_ARRAY(),1,'available'), ('Airport Residential Apartment','airport-residential-apartment','rent','apartment',15000.00,'GHS',3,3,1800.00,'Airport Residential Area, Accra','Accra','Greater Accra','A premium apartment in a prime business-friendly location with easy access to major offices, restaurants and airport routes.',JSON_ARRAY('Elevator','Gym Access','Security','Backup Power','Fitted Kitchen'),NULL,JSON_ARRAY(),0,'available'); INSERT IGNORE INTO `tours` (`title`,`slug`,`destination`,`duration_days`,`price`,`currency`,`max_persons`,`description`,`itinerary`,`includes`,`excludes`,`featured_image`,`gallery`,`is_featured`,`is_active`) VALUES ('Accra City Premium Experience','accra-city-premium-experience','Accra, Ghana',1,850.00,'GHS',20,'A curated city tour covering culture, food, landmarks and premium travel support.',JSON_ARRAY('Pickup','City landmarks','Cultural experience','Drop-off'),JSON_ARRAY('Transport','Guide','Selected entry fees'),JSON_ARRAY('Personal shopping'),NULL,JSON_ARRAY(),1,1);