Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T08:28:11.920' ,`MLSNumber` = '43528465' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.877967' ,`Longitude` = '-94.886866' ,`PhotoCount` = '46' ,`PostalCode` = '77523' ,`RoomCount` = '9' ,`ListPrice` = '568990.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Winds' ,`StreetNumber` = '13514' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3429' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come HOME to Gehan\'s newest community -- St. Augustine Meadows!! City amenities include pools, a golf course, trails, dog park, sports courts and SO much more! Zoned to award winning Barbers Hill ISD! This GORGEOUS Dartmouth floorplan is 4 bedroom, 2.5 bath plus gameroom, study, formal dining and 3 car garage with STUNNING brick elevation features HUGE OPEN family room, Omegastone countertops in kitchen with island & breakfast nook. PRIVATE master retreat with dual vanities, soaking tub + shower & HUGE walk-in closet! Spacious secondary bedrooms, high ceilings in family room!! RELAXING backyard with EXTENDED COVERED patio -- Perfect for entertaining! Make the call today!!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5, Block 3, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10400' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '455' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'St. Augustine Meadows' ,`TaxAmount` = '' ,`TaxRate` = '2.23' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675107162' WHERE `Matrix_Unique_ID` = '208646566' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T08:36:23.527' ,`MLSNumber` = '57134313' ,`ListAgentFullName` = 'Barbara Bullock' ,`ListOfficeName` = 'Brockway Realty' ,`SellingAgentFullName` = 'Phyllis Gibson' ,`SellingOfficeName` = 'Phyllis Gibson Realty' ,`Latitude` = '29.599093' ,`Longitude` = '-95.117283' ,`PhotoCount` = '47' ,`PostalCode` = '77059' ,`RoomCount` = '8' ,`ListPrice` = '274900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cavendish' ,`StreetNumber` = '15907' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1832' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DON\'T MISS YOUR OPPORTUNITY TO TOUR AND OWN THIS WELL TAKEN CARE OF, GREATLY LOVED, BEAUTIFULLY UPDATED, 3/2/2 WITH OFFICE (TEXAS BASEMENT) AND LARGE LAUNDRY ROOM IN HOUSE! IN THE WONDERFUL, SOUGHT AFTER COMMUNITY OF CLEAR LAKE CITY. HOME HAS NEW PAINT, COUNTERTOPS, BLINDS, LUXURY VINYL PLANK FLOORING, COZY FIREPLACE, LARGE, FULLY FENCED BACK YARD WITH COVERED PATIO AND HURRICANE CLIPS, NEW PEX PLUMBING THROUGHOUT. LOW TAX RATE AND LOW HOA! MOVE IN READY! NO FOUNDATION ISSUES!! ROOF HAS 30 YEAR SHINGLES AND 15 YEARS LEFT OF LIFE PER CONTRACTOR! SUBDIVISION HAS AN AREA POOL, RECREATIONAL FACILITY AND PLAYGROUND. SCHEDULE TO VIEW TODAY!! NEVER FLOODED!! ZONE X NO MANDATORY FLOOD INSURANCE REQUIRED BY LENDER.' ,`Acres` = '0.169' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 30 MIDDLEBROOK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '455' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ARMAND BAYOU ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Middlebrook Sec 02' ,`TaxAmount` = '4973' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675107162' WHERE `Matrix_Unique_ID` = '210631647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T08:58:46.523' ,`MLSNumber` = '40152836' ,`ListAgentFullName` = 'Frank Sitterle' ,`ListOfficeName` = 'Frank Sitterle, Broker' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.281852' ,`Longitude` = '-95.445694' ,`PhotoCount` = '6' ,`PostalCode` = '77301' ,`RoomCount` = '14' ,`ListPrice` = '827761.00' ,`Status` = 'Active' ,`StreetName` = 'Briac' ,`StreetNumber` = '998' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3347' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in the Wooded, Established Neighborhood of Stewart\'s Forest. 4 Bedroom, 3 Bath, Open Concept, Single Story Home with 3 Car Garage. 12\' Ceiling as You Enter and Flanked by the Formal Dining Room and Home Office. 12\' Ceiling at the 18\'x20\' Great Room with Floor Outlet and Prepared for TV Over the Fireplace. The Great Room is Open to the Island Kitchen Featuring Pendant Lighting, Cabinets to the Ceiling, 5 Burner, Gas Cooktop with Chimney Hood, and Walk-in Pantry. 9\'x16\' Covered Rear Patio with Fan. Laundry Will Be a Breeze in the Oversized Utility Room with Folding Area and Storage Cabinets. Drop Zone As You Enter from the 3 Car Garage. The Master En-Suite Bath Boasts Separate Vanities, Linen Closet, Separate Standing Shower, Soaking Tub, and a Great Walk-in Closet. Standing Shower at Bath 3. Double Sinks at Bath 2. All Bedrooms Have Walk-in Closets. Wi-Fi Enabled, Built-in Home Intelligence System with Smart Thermostat, Lighting Control, and Smart Entry Door Lock.' ,`Acres` = '0.2219' ,`Area` = '19' ,`BuilderName` = 'Sitterle Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S902410 - STEWARTS FOREST 10, BLOCK 2, LOT 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '9665' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '510' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stewarts Forest 10' ,`TaxAmount` = '517' ,`TaxRate` = '2.7863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675107162' WHERE `Matrix_Unique_ID` = '212741171' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T07:46:32.547' ,`MLSNumber` = '58704517' ,`ListAgentFullName` = 'Samantha Anderson' ,`ListOfficeName` = 'American Property Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.015784' ,`Longitude` = '-95.616135' ,`PhotoCount` = '37' ,`PostalCode` = '77377' ,`RoomCount` = '5' ,`ListPrice` = '529900.00' ,`Status` = 'Active' ,`StreetName` = 'Pedder Way' ,`StreetNumber` = '12431' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3738' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Private OASIS in your own backyard. Private inground pool with spa, and covered patio. All carpet has been removed and replaced with waterproof Vinyl planks. Walk into a fabulous 2 story entryway. Formal dining room, private office/study, living room, breakfast room, kitchen island and your primary bedroom are all downstairs. Walk up the staircase and you will be greeted by 4 bedrooms, 2 full bathrooms, an additional office/ study area with 2 built in desks, and a massive gameroom.' ,`Acres` = '0.2265' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 2 VILLAGE CREEK SEC 5' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9865' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '759' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Creek Sec 05' ,`TaxAmount` = '10629' ,`TaxRate` = '2.7564' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675107162' WHERE `Matrix_Unique_ID` = '213111284' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T08:10:36.860' ,`MLSNumber` = '4156465' ,`ListAgentFullName` = 'Jennifer Pye Cox' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749654' ,`Longitude` = '-95.429183' ,`PhotoCount` = '24' ,`PostalCode` = '77019' ,`RoomCount` = '11' ,`ListPrice` = '6299900.00' ,`Status` = 'Active' ,`StreetName` = 'Del Monte' ,`StreetNumber` = '3355' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '8593' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Gorgeous River Oaks stately home located in the highly sought after Country Club Estates, exudes timeless elegance. Situated on a beautiful 1/2 acre lot, this entertaining home has large living spaces with walls of windows looking out onto the gorgeous landscaped grounds with pool, spa and fountains.Beyond the gracious first floor living, the second floor provides four generous bedrooms with adjoining baths with great storage/closets and an additional third floor with an optional 5th Bedroom or Flex Space and full Bath. \r\nThis wonderfully custom designed River Oaks home is truly special!' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 8 River Country Club Estates' ,`LotDesciption` = 'Cleared,Subdivision Lot,Wooded' ,`LotSize` = '22500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'River Oaks Country Club Estate' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675107163' WHERE `Matrix_Unique_ID` = '214335165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T08:56:17.813' ,`MLSNumber` = '34907097' ,`ListAgentFullName` = 'Jimmy Zarate' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Michael Monge' ,`SellingOfficeName` = 'RE/MAX RESULTS' ,`Latitude` = '29.949354' ,`Longitude` = '-95.489820' ,`PhotoCount` = '23' ,`PostalCode` = '77066' ,`RoomCount` = '6' ,`ListPrice` = '215000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Conward' ,`StreetNumber` = '4706' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1716' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has been freshly painted. New updates to primary bathroom. Large covered patio with an oversized backyard. Tile in all areas except bedrooms have carpet. Ready to make it your own!' ,`Acres` = '0.2492' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 4 COPPER CREEK SEC 1 R/P & AMEND' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10857' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'KUJAWA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'SHOTWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Temporarily No Showings,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Copper Creek Sec 01 R/P & Amd' ,`TaxAmount` = '4287' ,`TaxRate` = '2.7553' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675107163' WHERE `Matrix_Unique_ID` = '214532202' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215250144','1675107163','215250144','2023-01-10T08:18:46.173','90306612','Cyndi Kornegay','Gatehouse Properties','','','30.158736','-95.395742','10','77385','7','399898.00','Active','Oakley Glen','31029','Court','Conroe','3','0','4','1975','Single-Family','The beautiful red brick exterior of this home offers great curb appeal. At the heart of the home, you will discover an open concept layout in the kitchen, family room and dining room. The gourmet kitchen boasts a massive island, perfect for the chef of the house. The primary suite is secluded at the back of the home and equipped with a luxurious primary bathroom with a separate shower and garden tub. Spend nights relaxing or entertaining on the huge covered patio. Don’t miss this home, visit today!','','15','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Spring Northeast','Central Gas','1','Lot 15 Block 1','Subdivision Lot','6000','Survey','','600','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','11 - Conroe','KAUFMAN ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','1','Traditional','The Meadows at Imperial Oaks','','3.31','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215353935','1675107163','215353935','2023-01-10T08:18:08.420','22221760','Cyndi Kornegay','Gatehouse Properties','','','30.158103','-95.395669','10','77385','7','359979.00','Active','Oakley Glen','31024','Court','Conroe','2','0','3','1687','Single-Family','The beautiful stone exterior of this home offers great curb appeal. Entering the home, you will find a flex room off the foyer. The gourmet kitchen is equipped with a massive island, that overlooks the family room. Tucked at the back of the home for added privacy, is the primary suite complete with a luxurious bathroom and large walk in closet. Spend nights relaxing outside on the covered patio. Visit this home today!','','15','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Spring Northeast','Central Gas','1','Lot 11 Block 1','Cul-De-Sac','6000','Survey','','600','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','11 - Conroe','KAUFMAN ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','1','Traditional','The Meadows at Imperial Oaks','','3.31','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215376678','1675107163','215376678','2023-01-10T08:12:25.060','86880113','Daniel Infante','United Real Estate','','','29.929082','-93.934674','14','77642','3','155000.00','Active','Vassar','4311','Street','Port Arthur','2','0','3','1342','Single-Family','Welcome home! This cute 3 bedroom 2 bath brick home is conveniently located near shopping, schools and local entertainment. The open floor plan lends itself to cooking while entertaining your guests. Updated kitchen and bathrooms await your family and friends enjoyment. Seller says bring all offer. Schedule your viewing today!','0.1928','51','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','','','','','Central Gas','0','LT 2 BLK 2 SMITH-YOUNG','Subdivision Lot','8400','Appraisal District','','','0','','2','Electric Oven,Freestanding Oven','0','','','Freestanding Range','','Composition','236 - Port Arthur','TYRRELL ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (PORT ARTHUR)','JEFFERSON MIDDLE SCHOOL (PORT ARTHUR)','Lockbox Front','Appraisal District','1','Traditional','Smith Young Add','3837','3.176','Public Sewer,Public Water,Water District','1968','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215427385','1675107163','215427385','2023-01-10T08:41:55.843','15385679','Ronnie Ashmore','By Owner.com','','','29.869421','-95.798616','20','77493','7','375000.00','Active','Northchester','6603','Drive','Katy','3','0','5','2209','Single-Family','Spacious home in Katy Lakes. NEW DEVELOPMENT - MOVE IN READY - LIGHT AND BRIGHT - CLEAN AND MODERN - OPEN FLOOR PLAN - MULTI-GENERATIONAL LIVING - PRIVATE BACKYARD - SEMI CUL-DE-SAC- PLAYGROUND - NEIGHBORHOOD POOL WITH SPLASH PAD - EASY ACESS TO 99 - EXEMPLARY KATY ISD SCHOOLS','0.1786','25','','','','','Mud','','','','Katy - Old Towne','Central Gas','1','LT 12 BLK 1 KATY LAKES SEC 2','Subdivision Lot','7781','Appraisal District','','900','0','','2','','0','','','Gas Cooktop','','Composition','30 - Katy','MCELWAIN ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','STOCKDICK JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Katy Lks Sec 2','12380','3.4868','Other Water/Sewer,Water District','2020','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215491056','1675107163','215491056','2023-01-10T08:47:35.837','33890657','David Markham','Markham Realty, Inc.','Roger Morton','RE/MAX The Woodlands & Spring','30.707333','-95.707800','14','77320','1','219500.00','Pending Continue to Show','Chandlers Way','154','','Huntsville','1','0','1','624','Single-Family','Just west of Huntsville lies some of the prettiest parts of Walker County and this one is no exception. This is a cute little cabin in the woods on 7.29 acres. The land is mostly wooded with scattered hardwood, pine, and plenty of shade. The cabin is about 624 square feet, with one bedroom and one bathroom. It has a newer metal roof and front porch for just the right amount of room to spread out. Only around 20-25 minutes from downtown, it has an easy access to town and I-45. So come see this side of the county, plan to relax and stay a while.','7.29','43','','','','','Sellers Disclosure','0','','0','Huntsville Area','Other Heating','0','7.29 Acres, Tract 7, in the B.W. Robinson Survey, A-42','Wooded','','','','','0','','0','Electric Oven','0','','','','','Aluminum','64 - Huntsville','SAMUEL W HOUSTON ELEMENTARY SCHOOL','HUNTSVILLE HIGH SCHOOL','MANCE PARK MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Other Style','none','','','Septic Tank','1997','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215851972','1675107163','215851972','2023-01-10T08:23:07.747','36707052','Joseph Petrie','Joseph and Company','','','29.382408','-95.309707','14','77511','6','269000.00','Active','County Road 184','13903','','Alvin','2','0','3','1344','Single-Family','Looking for living in the country This is it 3 bedroom 2 bath manufactured home on 2.5 acres. pond on the property is fenced for child safety. One car garage has an additional workshop space.','2.5','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Alvin South','Central Electric','0','A0432 Hooper &Wade tract PTB LT117','Cleared,Other','108900','Appraisal District','','','0','','1','Electric Oven','0','','','Electric Range','','Composition','3 - Alvin','NELSON ELEMENTARY SCHOOL (ALVIN)','ALVIN HIGH SCHOOL','FAIRVIEW JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Ranch','Hooper & Wade','','','Septic Tank,Well','1996','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216068529','1675107163','216068529','2023-01-10T08:01:00.130','48955787','Justin Dickey','Keller Williams Professionals','','','29.437035','-95.439379','8','77583','7','399990.00','Active','Amador Peak','10715','Drive','Rosharon','3','0','4','2175','Single-Family','Beautiful one story home features a spacious kitchen with stainless appliances, granite countertops, upgraded 42\" cabinets, vinyl flooring, a walk in pantry and is open to the huge family room. The master suite is separate from the other bedrooms and has a big walk in closet, standup shower and relaxing oval tub in master bath. Covered back patio to complete the house - it just needs you and your family to make it a home. PHOTOS ARE REPRESENTATIVE','','5','Colina Homes','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','','','Alvin North','Central Gas','1','Lot 14 Block 1 Sec 7','Subdivision Lot','','Survey','','900','1','To Be Built/Under Construction','3','Gas Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','1','Contemporary/Modern','Sierra Vista West','','','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216069697','1675107163','216069697','2023-01-10T07:58:39.237','67983006','Justin Dickey','Keller Williams Professionals','','','29.427618','-95.450759','46','77583','8','419990.00','Active','Tioga View','1903','Drive','Rosharon','3','0','4','2543','Single-Family','Beautiful one story with 4 bedrooms, 3 full baths plus study/dining room. Two sinks in primary bath with garden tub and stand-alone shower with seat, XLarge primary closet. High ceilings throughout the home with vestibule in the entry. Granite Kitchen with deep under-mount sink. 42” cabinets, Stainless Steel 5 burner gas range, microwave and dishwasher 2” blinds standard along with windstorm panels, large covered patio. EST Completion 1/31/23. PICTURES ARE REPRESENTATIVE- Not the actual home.','','5','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Alvin North','Central Gas','1','Lot 3 BLK 3 Sec 7','Subdivision Lot','7927','Appraisal District','','900','1','To Be Built/Under Construction','3','Gas Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany,Leave Business Card','Builder','1','Contemporary/Modern','Sierra Vista West','','3.6','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216069876','1675107163','216069876','2023-01-10T07:57:22.237','42156719','Justin Dickey','Keller Williams Professionals','','','29.427806','-95.450420','33','77583','8','439990.00','Active','Tioga View','1726','Drive','Rosharon','3','1','4','2922','Single-Family','This gorgeous Colina Home has Amazing offerings! When you walk through the front door you will feel right at home. This home offers 4bedrooms,3.5bathrooms,dining & 3car garage! The living room, kitchen,area are open to each other with high ceilings. The kitchen features oversized island with seating,42\" cabinetry,& spacious walk in pantry. The primary bedroom is tucked away in the back of home with a spacious en suite bathroom & walk in closet. There is a Huge covered back patio great for grilling and fun. Rosharon\'s best communities offering everything a family friendly community want + amenities located in Sterling Lakes, with a spashpad, fitness center,Basketball Court, Lakes & Parks. Crystal Lagoon coming soon! Close to Pearland, Alvin,Manvel, Lake Jackson,30 minutes from Downtown Houston. SHOP AND WORK IN THE CITY AND\r\nCOME HOME TO A QUIET PEACEFUL COMMUNITY @ SIERRA VISTA!','','5','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Alvin North','Central Gas','1','Lot 1 Block 5 Sec 7','Subdivision Lot','8960','Survey','','1100','1','To Be Built/Under Construction','3','Gas Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany,Leave Business Card','Builder','2','Contemporary/Modern','Sierra Vista','','','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216070525','1675107163','216070525','2023-01-10T07:51:51.463','52340551','Justin Dickey','Keller Williams Professionals','','','29.427598','-95.451366','44','77583','8','417990.00','Active','Sequoia Grove','2417','Drive','Rosharon','3','0','4','2543','Single-Family','Beautiful one story with 4 bedrooms, 3 full baths plus study/dining room. Two sinks in primary bath with garden tub and stand-alone shower with seat, XLarge primary closet. High ceilings throughout the home with vestibule in the entry. Granite Kitchen with deep under-mount sink. 42” cabinets, Stainless Steel 5 burner gas range, microwave and dishwasher 2” blinds standard along with windstorm panels, large covered patio. EST Completion 2/28/23. PICTURES ARE REPRESENTATIVE- Not the actual home.','','5','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Alvin North','Central Gas','1','Lot 7 BLK 1 Sec 6','Subdivision Lot','7197','Appraisal District','','900','1','To Be Built/Under Construction','3','Gas Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany,Leave Business Card','Builder','1','Contemporary/Modern','Sierra Vista West','','3.6','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216109104','1675107164','216109104','2023-01-10T08:06:50.997','9432368','Jennifer Sheridan','Keller Williams RealtyNortheast','','','30.053020','-95.222210','32','77339','8','369000.00','Active','Riverlawn','2014','','Kingwood','2','1','4','2844','Single-Family','Meticulously maintained home that includes a WHOLE HOME GENERATOR. Situated in a well-established neighborhood that\'s close to all the great amenities of Kingwood including entertainment, dining and shopping. This spacious home located in Humble ISD features a large living area with floor to ceiling windows and a grand fireplace, kitchen w/ granite countertops, breakfast nook and plenty of storage, separate dining room, office/flex space, comfortable 1st floor primary bedroom overlooking the well maintained/back yard and many custom features throughout. 2019-water heater replaced, 2022-HVAC replaced - Whole home water filtration unit - 2021 Generac whole-home generator installed, double pane windows, insulated garage, roof replaced in 2014. This home offers both character and space. You have to see it, to appreciate it!','','32','','','','','No Disclosures','1','','1','Kingwood West','Central Gas','1','LOT 3 BLK 7 WOODLAND HILLS VILLAGE SEC 11','Subdivision Lot','8024','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','29 - Humble','WOODLAND HILLS ELEMENTARY SCHOOL','KINGWOOD PARK HIGH SCHOOL','KINGWOOD MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Woodland Hills Village','','','Public Sewer,Public Water','1980','Appraisal District'); --> New record created successfully