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` = '2022-12-14T11:38:47.003' ,`MLSNumber` = '46407758' ,`ListAgentFullName` = 'Diane Kink' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.185752' ,`Longitude` = '-95.546613' ,`PhotoCount` = '19' ,`PostalCode` = '77382' ,`RoomCount` = '9' ,`ListPrice` = '2450000.00' ,`Status` = 'Active' ,`StreetName` = 'Bunnelle' ,`StreetNumber` = '11' ,`StreetSuffix` = 'Way' ,`City` = 'The Woodlands' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5570' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Discover your dream home and enjoy resort-style living in a tranquil setting located behind the private gates of Carlton Woods. Underway by Novi Home Builders Corp, this outstanding custom home builder offers another luxury single-family residence with an ideal location, exceptional resort-style amenities, beautiful scenery, and highly rated Montgomery County Public and Private Schools. Clean lines, contemporary/modern elements throughout. Two bedrooms down, three up all en suite baths. Spend an afternoon playing a round of golf on the Jack Nicklaus golf course or enjoy dinner at the club on the patio overlooking the green. Amenities include tennis, swimming, workout center, walking trails, and much more!' ,`Acres` = '0.2888' ,`Area` = '15' ,`BuilderName` = 'Novi Home Builders' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'WDLNDS VIL OF CARLTON WOODS 05, BLOCK 1, LOT 28' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '12579' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'TOUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Wdlnds Village Of Carlton Woods' ,`TaxAmount` = '2709' ,`TaxRate` = '2.2431' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090989' WHERE `Matrix_Unique_ID` = '202119298' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T12:53:14.340' ,`MLSNumber` = '81201788' ,`ListAgentFullName` = 'Kayla Fisher' ,`ListOfficeName` = 'CB&A, Realtors- Southeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847004' ,`Longitude` = '-94.225606' ,`PhotoCount` = '49' ,`PostalCode` = '77705' ,`RoomCount` = '9' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Boondocks' ,`StreetNumber` = '16893' ,`StreetSuffix` = 'Road' ,`City` = 'Beaumont' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3817' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You don\'t want to miss out on this one of a kind waterfront property on Taylor\'s Bayou. Enjoy the tranquil scenery with over 300 ft of water front access and multiple decks to overlook the water. Entertain in the open concept kitchen and large living area that overlooks water with large custom windows. With a gas stove, marble cabinets, stainless appliances, you will never want to leave the spacious kitchen! The master suite includes a soaking tub, separate shower and custom cabinets. The two upstairs rooms are great for guests or office space. Don\'t miss the down stairs game room that has a full shower, closet and can be fitted with a full kitchen. This space would be great for a mother in law suit or even a garage apartment. Fully remodeled and ready to enjoy! Schedule your showing today!' ,`Acres` = '0.94' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 68 191 WM REEVES .9357' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '40946' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '110 - Hamshire-Fannett' ,`SchoolElementary` = 'HAMSHIRE-FANNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HAMSHIRE-FANNETT HIGH SCHOOL' ,`SchoolMiddle` = 'HAMSHIRE-FANNETT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2.5' ,`Style` = 'Traditional' ,`Subdivision` = 'None' ,`TaxAmount` = '5014' ,`TaxRate` = '2.1544' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090989' WHERE `Matrix_Unique_ID` = '209847522' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T11:04:44.913' ,`MLSNumber` = '81834436' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.155154' ,`Longitude` = '-95.394974' ,`PhotoCount` = '10' ,`PostalCode` = '77385' ,`RoomCount` = '10' ,`ListPrice` = '549849.00' ,`Status` = 'Active' ,`StreetName` = 'Noble Creek' ,`StreetNumber` = '32311' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a spacious, open floor plan? This stunning one-story home boasts just what you have been searching for. An extended foyer greets you as you walk through the door paving your way into the heart of the home. Featuring high 14\' ceilings with an open floor plan between the kitchen, family room and dining area, this space is ideal for entertaining. The gorgeous kitchen is equipped with a huge island and stainless-steel appliances. Work from home in the study that flanks the kitchen and family room. Relax for the evening on the large covered patio. Additional entertaining space is found in the game room located at the back of the home. We are proud to deliver the finest quality workmanship. Come visit this stunning home today!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8213' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Meadows at Imperial Oaks' ,`TaxAmount` = '' ,`TaxRate` = '3.3' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090989' WHERE `Matrix_Unique_ID` = '209933249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T11:35:45.160' ,`MLSNumber` = '29107363' ,`ListAgentFullName` = 'Jody Ricco' ,`ListOfficeName` = 'Ricco Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.949753' ,`Longitude` = '-95.366548' ,`PhotoCount` = '23' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = '8th' ,`StreetNumber` = '1414' ,`StreetSuffix` = 'Street' ,`City` = 'Freeport' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '951' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This adorable home has been completely remodeled and is move-in ready. The updated kitchen has gorgeous white cabinets and granite counter tops. The large island offers additional storage and the extended granite counter is perfect for barstools. Subway tile backsplash has a clean and modern feel. Stainless appliances are new and haven\'t been used. The bathroom has gorgeous tile in the oversized shower. New vanity and sink. Tile floors in the kitchen and bath. The hardwood floors have been refinished and look amazing! The electrical and plumbing systems have been updated. Recent front and back doors, sheetrock and paint. Pendant lighting, recessed lighting throughout living and kitchen. Attached garage. Large front yard and alley in back yard for garage access. Extended driveway provides additional parking. Foundation repaired January 2022.' ,`Acres` = '0.1607' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FREEPORT, BLOCK 155, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Freeport' ,`TaxAmount` = '1872' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1942' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090990' WHERE `Matrix_Unique_ID` = '210418262' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T11:02:46.530' ,`MLSNumber` = '25032564' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472905' ,`Longitude` = '-95.531236' ,`PhotoCount` = '33' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '499793.00' ,`Status` = 'Active' ,`StreetName` = 'Waters Branch' ,`StreetNumber` = '1959' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2065' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous 1-story home complements a modern brick and stucco exterior. You will be welcomed by soaring ceilings and stunning wood plank tile flooring throughout the house. The bold gourmet kitchen is equipped with gleaming granite countertops and a large island overlooking the family room and dining room. Relax in the elegant primary suite with a spa-like garden tub, a separate walk-in shower, and an oversized walk-in closet. Enjoy entertaining family and friends outdoors on the spacious covered back patio. Come and visit this luxurious home today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6123' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1229' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090990' WHERE `Matrix_Unique_ID` = '210668746' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T11:02:28.590' ,`MLSNumber` = '65648959' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.526786' ,`Longitude` = '-95.415474' ,`PhotoCount` = '43' ,`PostalCode` = '77578' ,`RoomCount` = '5' ,`ListPrice` = '399990.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Butte' ,`StreetNumber` = '4806' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1483' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely one-story home was designed with you in mind! The bold kitchen is highlighted by stunning granite countertops, stainless steel appliances and a spacious island that overlooks the casual dining area and family room. The elegant primary suite is complete with a spa-like bathroom that includes a garden tub and separate walk-in shower. Come visit this spectacular home today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5999' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1190' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Pomona' ,`TaxAmount` = '' ,`TaxRate` = '3.51' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090990' WHERE `Matrix_Unique_ID` = '210900773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T11:02:09.900' ,`MLSNumber` = '80946782' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.979579' ,`Longitude` = '-95.742600' ,`PhotoCount` = '6' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '599998.00' ,`Status` = 'Active' ,`StreetName` = 'Via Casa Linda' ,`StreetNumber` = '20706' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2851' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous two-story home welcomes you in through the foyer and leads to a beautiful spiral staircase. The open-concept kitchen boasts tons of storage space, stainless-steel appliances, and opens to the family room which features 19\' ceilings. Retreat to your spacious primary suite with an oversized walk-in closet and garden tub with a separate shower. Head out back to the covered patio to enjoy a relaxing Texas sunset. This home has amazing upgrades including beautiful wood flooring in the main living areas, a home office, 3-car garage, game room and media room for all to enjoy. Don\'t miss out on this incredible home!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '6089' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'English,Traditional' ,`Subdivision` = 'Dunham Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090990' WHERE `Matrix_Unique_ID` = '210936889' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T11:01:40.997' ,`MLSNumber` = '62209089' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.682825' ,`Longitude` = '-95.738236' ,`PhotoCount` = '39' ,`PostalCode` = '77407' ,`RoomCount` = '7' ,`ListPrice` = '587632.00' ,`Status` = 'Active' ,`StreetName` = 'Granary Gate' ,`StreetNumber` = '8822' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2816' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful one-story floor plan boasts everything you have been dreaming of and more. As you enter the elegant foyer, you will discover a study complemented by glass French doors and a secondary bedroom with its own private bath and walk-in closet. Following the extended foyer, you will be escorted into the heart of the home. The kitchen offers ample amounts of counter space to prepare multiple meals for any occasion. Your guests will be able to enjoy time out on the covered patio, while you prepare for dinner. Complete with a three-car garage, what’s not to love?' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7645' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Grand Mission Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.96' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090990' WHERE `Matrix_Unique_ID` = '211205866' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T11:01:24.523' ,`MLSNumber` = '44867922' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.979579' ,`Longitude` = '-95.742600' ,`PhotoCount` = '6' ,`PostalCode` = '77433' ,`RoomCount` = '13' ,`ListPrice` = '799989.00' ,`Status` = 'Active' ,`StreetName` = 'Via Del Corso' ,`StreetNumber` = '20739' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4161' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come visit this fabulous home in Dunham Pointe. As you pull into the driveway, you will be mesmerized by the gorgeous stucco and stone elevation. Entering the home, you are greeted by stunning hardwood floors that flow throughout the main living areas. The chef of the family will enjoy the gourmet kitchen equipped with modern cabinetry, stunning countertops and stainless-steel appliances. Ideal for guests, there is a second bedroom located on the first floor. Enjoy entertaining by stepping through the sliding glass doors onto the massive covered patio. Spend family time in the spacious game room, or the media room. There is something for everyone in this home. After a long day, retreat to the luxurious primary suite enhanced with bay windows and an oversized bathroom. You have found your new home.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 4' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11826' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`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` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Dunham Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090991' WHERE `Matrix_Unique_ID` = '211254025' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T11:01:08.517' ,`MLSNumber` = '64062489' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.470285' ,`Longitude` = '-95.533231' ,`PhotoCount` = '27' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '469187.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Trail' ,`StreetNumber` = '1815' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2065' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous one-story home is complemented with a vibrant, timeless brick exterior. As you enter, you will be welcomed by soaring ceilings and stunning wood plank tile flooring throughout the home. The bold gourmet kitchen is equipped with gleaming granite countertops and a large island overlooking the family room and dining room. Relax in the elegant primary suite which boasts a spa-like walk-in shower complete with a mud set tile and an oversized walk-in closet. Impress your family and friends with a meal from your outdoor kitchen and entertain on the spacious covered back patio. Come visit this luxurious home today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 Block 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '7102' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1229' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090991' WHERE `Matrix_Unique_ID` = '211359899' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T12:34:32.030' ,`MLSNumber` = '90193333' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.141428' ,`Longitude` = '-93.786723' ,`PhotoCount` = '18' ,`PostalCode` = '77632' ,`RoomCount` = '8' ,`ListPrice` = '374990.00' ,`Status` = 'Active' ,`StreetName` = 'Allie Payne' ,`StreetNumber` = '3413' ,`StreetSuffix` = 'Road' ,`City` = 'Orange' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Irving x50l is a gorgeous single-story by America\'s Builder D.R. Horton located in Oak Allie. Offering a spacious 2,594 square feet home, 5 bedroom, 3 bathroom, 2-car garage plan. Ranch style layout which ideal for entertaining. The foyer leads you into the spacious dining room just off the living room. This layout offers a large open concept kitchen with a granite island and is equipped with a large walk-in pantry, Whirlpool Stainless Steel appliances and a gas range. A beautiful bedroom En-Suite located at the rear of the house for complete privacy. Enjoy working from home in your study, perfect for a home office! The exterior comes with front and back sod, landscaping in the front, and a large covered patio! With numerous bedrooms and large living areas, this plan has everything you’ve been looking for!' ,`Acres` = '0.479' ,`Area` = '50' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OAK ALLIE, LOT 10, ACRES 0.48' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '20865' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '683 - Little Cypress-Mauriceville Consolidated' ,`SchoolElementary` = 'LITTLE CYPRESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LITTLE CYPRESS-MAURICEVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'LITTLE CYPRESS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Oak Allie' ,`TaxAmount` = '185' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090991' WHERE `Matrix_Unique_ID` = '212979926' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T12:18:35.623' ,`MLSNumber` = '16567712' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.141428' ,`Longitude` = '-93.786723' ,`PhotoCount` = '16' ,`PostalCode` = '77632' ,`RoomCount` = '7' ,`ListPrice` = '339990.00' ,`Status` = 'Active' ,`StreetName` = 'Allie Payne' ,`StreetNumber` = '3409' ,`StreetSuffix` = 'Road' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2134' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Garland is a single story home by America\'s Home Builder D.R. Horton located in Oak Allie ! With 4 bedrooms and 2 bathrooms, offering 2,194 square feet of living space. As you enter the home into the foyer, you will pass all three, spacious, extra bedrooms, a large extra bathroom, and the open laundry room. Continuing down the foyer, into the home, you will enter the wide open living space with plenty of natural lighting. The spacious kitchen offers a large kitchen island, walk-in pantry, granite countertops, stainless steel appliances, and decorative tile backsplash. The kitchen island overlooks the large dining room that faces the covered patio and backyard. The family room is just off the dining and provides plenty of open space, perfect for entertaining. The main bedroom, bedroom 1, is located privately off the dining area and offers tons of space and a huge walk-in closet.' ,`Acres` = '0.479' ,`Area` = '50' ,`BuilderName` = 'D.R. HOrton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OAK ALLIE, LOT 12, ACRES 0.48' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20865' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '683 - Little Cypress-Mauriceville Consolidated' ,`SchoolElementary` = 'LITTLE CYPRESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LITTLE CYPRESS-MAURICEVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'LITTLE CYPRESS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Allie' ,`TaxAmount` = '185' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090991' WHERE `Matrix_Unique_ID` = '213145560' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T12:38:11.580' ,`MLSNumber` = '62964627' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.141428' ,`Longitude` = '-93.786723' ,`PhotoCount` = '16' ,`PostalCode` = '77632' ,`RoomCount` = '7' ,`ListPrice` = '344990.00' ,`Status` = 'Active' ,`StreetName` = 'Allie Payne' ,`StreetNumber` = '3401' ,`StreetSuffix` = 'Road' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2134' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Garland is a single story home by America\'s Home Builder D.R. Horton located in Oak Allie! An open concept floorplan with 4 bedrooms and 2 bathrooms, offering 2,194 square feet of living space. As you enter the home into the foyer, you will pass all three, spacious, extra bedrooms, a large extra bathroom, and the open laundry room. Continuing down the foyer, into the home, you will enter the wide open living space with plenty of natural lighting. The spacious kitchen offers a large kitchen island, walk-in pantry, granite countertops, stainless steel appliances, and decorative tile backsplash. The kitchen island overlooks the large dining room that faces the covered patio and backyard. The family room is just off the dining and provides plenty of open space, perfect for entertaining. The main bedroom, bedroom 1, is located privately off the dining area and offers tons of space and a huge walk-in closet.' ,`Acres` = '0.463' ,`Area` = '50' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OAK ALLIE, LOT 16, ACRES 0.463' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20168' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '683 - Little Cypress-Mauriceville Consolidated' ,`SchoolElementary` = 'LITTLE CYPRESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LITTLE CYPRESS-MAURICEVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'LITTLE CYPRESS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Allie' ,`TaxAmount` = '178' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090992' WHERE `Matrix_Unique_ID` = '213183818' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T12:39:12.150' ,`MLSNumber` = '65731440' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.141428' ,`Longitude` = '-93.786723' ,`PhotoCount` = '12' ,`PostalCode` = '77632' ,`RoomCount` = '6' ,`ListPrice` = '329990.00' ,`Status` = 'Active' ,`StreetName` = 'Allie Payne' ,`StreetNumber` = '3403' ,`StreetSuffix` = 'Road' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2036' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Eureka Plan a 2036 square foot single story home by America\'s Home Builder D.R. Horton located in Oak Allie! Tour this stunning home with front elevation divided light windows, lighted front porch / back patio. The interior includes raised panel interior doors with designer lever handles and smart door lock on front exterior door. Your gourmet kitchen includes granite countertops, stainless steel range and dishwasher. Enjoy your main bedroom suite including a large walk-in closet & ensuite. Home features a tankless water heater and a smart home package.' ,`Acres` = '0.479' ,`Area` = '50' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OAK ALLIE, LOT 15, ACRES 0.48' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20865' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '683 - Little Cypress-Mauriceville Consolidated' ,`SchoolElementary` = 'LITTLE CYPRESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LITTLE CYPRESS-MAURICEVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'LITTLE CYPRESS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Allie' ,`TaxAmount` = '185' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090992' WHERE `Matrix_Unique_ID` = '213192542' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T12:42:44.990' ,`MLSNumber` = '57393380' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.141428' ,`Longitude` = '-93.786723' ,`PhotoCount` = '10' ,`PostalCode` = '77632' ,`RoomCount` = '7' ,`ListPrice` = '349990.00' ,`Status` = 'Active' ,`StreetName` = 'Allie Payne' ,`StreetNumber` = '3407' ,`StreetSuffix` = 'Road' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2134' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Holden is a single story home by America\'s Home Builder D.R. Horton located in Oak Allie! Open concept floorplan with 4bedrooms and 2 bathrooms, offering 2,394 square feet of living space. As you enter the home into the foyer, you will pass all three, spacious, a large extra bathroom, and the laundry room. Continuing down the foyer, into the home, you will enter the wide open living space with plenty of natural lighting. The spacious kitchen offers a large kitchen island, walk-in pantry, granite countertops, stainless steel appliances, and decorative tile backsplash. The kitchen island overlooks the spacious dining room that faces the covered patio and backyard. The family room is just off the dining room and provides plenty of open space, perfect for entertaining. The primary suite has a huge walk in closet and dual vanities.' ,`Acres` = '0.479' ,`Area` = '50' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OAK ALLIE, LOT 13, ACRES 0.48' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20865' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '683 - Little Cypress-Mauriceville Consolidated' ,`SchoolElementary` = 'LITTLE CYPRESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LITTLE CYPRESS-MAURICEVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'LITTLE CYPRESS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Allie' ,`TaxAmount` = '185' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090992' WHERE `Matrix_Unique_ID` = '213192647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T12:33:30.833' ,`MLSNumber` = '90751002' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.141428' ,`Longitude` = '-93.786723' ,`PhotoCount` = '12' ,`PostalCode` = '77632' ,`RoomCount` = '6' ,`ListPrice` = '329990.00' ,`Status` = 'Active' ,`StreetName` = 'Allie Payne' ,`StreetNumber` = '3411' ,`StreetSuffix` = '' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2036' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Eureka Plan a 2036 square foot single story home by America\'s Home Builder D.R. Horton located in Oak Allie! Tour this stunning home with front elevation divided light windows, lighted front porch / back patio. The interior includes raised panel interior doors with designer lever handles and smart door lock on front exterior door. Your gourmet kitchen includes granite countertops, stainless steel range and dishwasher. Enjoy your main bedroom suite including a large walk-in closet & ensuite. Home features a tankless water heater and a smart home package.' ,`Acres` = '' ,`Area` = '50' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OAK ALLIE, Lot 11, ACRES 0.48' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '20865' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '683 - Little Cypress-Mauriceville Consolidated' ,`SchoolElementary` = 'LITTLE CYPRESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LITTLE CYPRESS-MAURICEVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'LITTLE CYPRESS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mallard Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090992' WHERE `Matrix_Unique_ID` = '213240517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T12:15:49.847' ,`MLSNumber` = '89183856' ,`ListAgentFullName` = 'Jaime Black' ,`ListOfficeName` = 'Martin & Black Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.399959' ,`Longitude` = '-95.254005' ,`PhotoCount` = '35' ,`PostalCode` = '77511' ,`RoomCount` = '7' ,`ListPrice` = '264999.00' ,`Status` = 'Active' ,`StreetName` = 'Colt Creek' ,`StreetNumber` = '1187' ,`StreetSuffix` = 'Court' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1839' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Meticulous Mustang Crossing home nestled on a quiet cul-de-sac street with no back neighbors! New landscaping greets you to the covered front porch with a stylish lead-glass front door and into the open living space with soaring ceilings, highlighted by new carpet and interior paint throughout the home. Continuing to the breakfast bar and island kitchen with stainless steel refrigerator, extensive cabinetry and walk-in pantry along with a large dining space provides room for all. First floor master retreat with ensuite bath featuring a soaking tub, separate shower and walk-in closet. Upstairs offers a roomy game room with a large storage closet, 2 bedrooms highlighted by crown molding and spacious closets and a full bath. A new windstorm certified backdoor leads to the 10x30 back patio, perfect for gatherings! No MUD tax and No Flooding! Convenient park just down the street! Come take a look!' ,`Acres` = '0.128' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MUSTANG CROSSING SEC 1 (A0488 H & W) (ALVIN) BLK 1 LOT 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5576' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '340' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'ALVIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mustang Crossing' ,`TaxAmount` = '6180' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090993' WHERE `Matrix_Unique_ID` = '214064678' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T12:13:11.650' ,`MLSNumber` = '85120639' ,`ListAgentFullName` = 'Toke Ettehadieh' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.020891' ,`Longitude` = '-95.507398' ,`PhotoCount` = '44' ,`PostalCode` = '77379' ,`RoomCount` = '17' ,`ListPrice` = '549786.00' ,`Status` = 'Active' ,`StreetName` = 'Perry Pass' ,`StreetNumber` = '16311' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4079' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2-Story, 5 Bedroom, 4/2 Bathroom Home on a Quite Cul-De-Sac. Primary Bedroom on the 1st Floor along with a Fabulous Open Kitchen and a Living Room with Soaring Ceilings. Home features Formal Dining, Home Office, Upstairs Game Room, 4 Bedrooms Upstairs and an amazing Outdoor Patio complete with Pergola and Outdoor Kitchen. Check out the Virtual Tour and Schedule a Viewing Today!' ,`Acres` = '0.2296' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 1 WIMBLEDON CHAMPIONS SEC 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MITTELSTADT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wimbledon Champions Sec 3' ,`TaxAmount` = '9376' ,`TaxRate` = '2.6165' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090993' WHERE `Matrix_Unique_ID` = '214101967' --> 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','214514086','1675090993','214514086','2022-12-14T11:56:37.087','22848145','Sapramjeet Singh','SJS International LLC','','','29.709623','-95.439053','14','77005','7','2495000.00','Active','Southwestern','3832','Street','Houston','5','0','4','4270','Single-Family','Stunning new construction transitional home by SJS Group. This home has 4 bdrm, 5 full baths with 2 car garage. Full home automation system from Crestron, floor to ceiling glass doors lead to an entertainers dream yard with impressive outdoor patio & outdoor kitchen. Additional amenities include private office or flex room on the first floor, elevator capability, open floor plan, bar area, designer lighting fixtures, & immense natural light throughout this home are truly captivating. One of a kind kitchen with waterfall island, soft close cabinets, premium appliances (Wolf, Cove, Sub-zero), central vacuum, luxurious master retreat, massive master bathroom with exotic natural stones and accent walls. Modern house made with exquisite taste and delicate finishes creates the perfect lifestyle!','0.1377','17','SJS Development','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','2','West University/Southside Area','Central Electric,Central Gas','0','LT 17 & TR 18A BLK 3 COLLEGEVIEW SEC 1','Cleared','6000','Appraisal District','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Other','27 - Houston','WEST UNIVERSITY ELEMENTARY SCHOOL','LAMAR HIGH SCHOOL (HOUSTON)','PERSHING MIDDLE SCHOOL','Appointment Required,Leave Business Card','Builder','2','Contemporary/Modern','Collegeview Sec 01','15200','2.0584','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T12:11:29.613' ,`MLSNumber` = '97982828' ,`ListAgentFullName` = 'Toke Ettehadieh' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.591990' ,`Longitude` = '-95.520980' ,`PhotoCount` = '32' ,`PostalCode` = '77489' ,`RoomCount` = '9' ,`ListPrice` = '289786.00' ,`Status` = 'Active' ,`StreetName` = 'Fieldstone' ,`StreetNumber` = '1319' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious 4 Bedroom, 2 Bathroom home zoned to Fort Bend ISD. This move-in ready home features a great open living area, high ceilings and wood flooring in the living and dining room. Primary bedroom with high ceilings, walk-in closet and updated bathroom. Low tax rate and low annual HOA fee. Check out the virtual tour and schedule a viewing today!' ,`Acres` = '0.1736' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HUNTERS GLEN SEC 3, BLOCK 1, LOT 49' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7562' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HUNTERS GLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Glen Sec 3' ,`TaxAmount` = '4769' ,`TaxRate` = '2.693' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090993' WHERE `Matrix_Unique_ID` = '214622360' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T12:11:17.370' ,`MLSNumber` = '5710142' ,`ListAgentFullName` = 'Toke Ettehadieh' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.033145' ,`Longitude` = '-95.450869' ,`PhotoCount` = '32' ,`PostalCode` = '77090' ,`RoomCount` = '7' ,`ListPrice` = '289786.00' ,`Status` = 'Active' ,`StreetName` = 'Leinad' ,`StreetNumber` = '18319' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1692' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful Ranch-style Three Bedroom, Two Bathroom home. Great sized living room open to the beautifully updated kitchen. Primary bedroom features a large walk-in closet and a luxurious bathroom w italian tiled flooring and tub! This home is move-in ready. Check out the virtual tour and schedule a viewing today.' ,`Acres` = '0.2704' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 PINE OAK FOREST EXTN U/R SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11777' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'BAMMEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Pine Oak Forest Ext U/R Sec 01' ,`TaxAmount` = '991' ,`TaxRate` = '2.1392' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090993' WHERE `Matrix_Unique_ID` = '214622613' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T12:31:29.733' ,`MLSNumber` = '9291125' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151554' ,`Longitude` = '-94.141141' ,`PhotoCount` = '27' ,`PostalCode` = '77708' ,`RoomCount` = '8' ,`ListPrice` = '309990.00' ,`Status` = 'Active' ,`StreetName` = 'Riplee Street' ,`StreetNumber` = '6655' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2041' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Kingston Elevation O plan is a one-story home featuring 4 bedrooms, 2 baths, and 2 car garage beautifully crafted new construction home by D.R. Horton.. The entry opens to the guest bedrooms, bath with linen closet. Center kitchen includes oversized breakfast bar with beautiful counter tops and stainless-steel appliances. Open concept floorplan boasts large, combined family room and dining area. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and walk-in closet. The standard rear covered patio is located off the family room. Beaumont\'s trendy hidden neighborhood, Spring Wood is tucked away on RFD Road just off FM 105 and Major Drive. Schedule your tour today!' ,`Acres` = '' ,`Area` = '51' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '000000000000000' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'HOMER DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'KING MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sring Wood' ,`TaxAmount` = '' ,`TaxRate` = '2.6134' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090994' WHERE `Matrix_Unique_ID` = '214947284' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T12:36:32.553' ,`MLSNumber` = '51077905' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Myrna Aguirre' ,`SellingOfficeName` = 'Lone Star Realty' ,`Latitude` = '29.851522' ,`Longitude` = '-95.746002' ,`PhotoCount` = '7' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '280490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'BAY MEADOWS LANE' ,`StreetNumber` = '5147' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1415' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING BRAND NEW DR HORTON HOME IN THE BEST LOCATION!! Perfect 1 story floor plan with everything you have been looking for!! Great open living spaces, modern finishes, designer details, lovely primary suite, and so much more!! Beautiful island kitchen! Perfect for entertaining!!Lovely outdoor space with useful covered back patio! Includes landscape package!! Don\'t miss this opportunity!! Hurry and call today! This property will sell fast!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 3 Block 2 Section 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090994' WHERE `Matrix_Unique_ID` = '214947480' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T12:24:20.200' ,`MLSNumber` = '48652431' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151554' ,`Longitude` = '-94.141141' ,`PhotoCount` = '15' ,`PostalCode` = '77708' ,`RoomCount` = '6' ,`ListPrice` = '267990.00' ,`Status` = 'Active' ,`StreetName` = 'Riplee Street' ,`StreetNumber` = '6710' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1501' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Camden elevation P is a one-story home featuring 3 bedrooms, 2 baths, and 2 car garage new Construction home by D.R. Horton. Located in Beaumont\'s trendy hidden neighborhood, Spring Wood is tucked away on RFD Road just off FM 105 and Major Drive. The gourmet kitchen includes granite counter tops, stainless steel appliances and open concept floorplan with the dining room opening to the kitchen and family room. The primary suite features an attractive primary bath with optional separate tub and shower and spacious his and hers walk-in closets. The rear covered patio comes built standard and is located off the family room . Schedule your tour today!' ,`Acres` = '' ,`Area` = '51' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '0000000000' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'HOMER DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'KING MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Wood' ,`TaxAmount` = '' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '223' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090994' WHERE `Matrix_Unique_ID` = '214966420' --> 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','215236092','1675090994','215236092','2022-12-14T12:12:13.650','73995202','Raquel Doss','Ace Realty','','','29.793899','-95.166895','29','77015','4','270000.00','Active','Foxford','14407','Way','Houston','2','0','3','1537','Single-Family','Lovely three-bedroom two bathroom home in the much-desired Galena Park I.S.D. The kitchen has been updated to an open kitchen layout with custom-built Hickory cabinets. The primary bath has been updated with Custom Hickory cabinets and an open walk-in shower. The home has a New Electrical Panel. New AC ductwork. new piping with PEX. There is a new Cummings 20 KW whole-house generator. That comes with home There is also a side carport with an enclosed dog run.','0.1701','2','','','','','Sellers Disclosure','','','','North Channel','Central Electric','1','LT 3 BLK 23 WOODFOREST SEC 15','Subdivision Lot','7410','Appraisal District','','300','0','','3','','0','','','','','Composition','21 - Galena Park','NORTH SHORE ELEMENTARY SCHOOL','NORTH SHORE SENIOR HIGH SCHOOL','NORTH SHORE MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Other Style','Woodforest Sec 15','4693','2.5294','Public Sewer,Public Water','1970','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','215596274','1675090994','215596274','2022-12-14T12:16:07.927','23455051','Vi Tran','JPAR-The Sears Group','','','29.909484','-95.455789','50','77038','4','325000.00','Active','Amber Thicket Ct','2619','','Houston','2','1','4','3359','Single-Family','Beautiful two-story, 4 bed, 2.5 bath, brick home in Westview Landing neighborhood. Gorgeous open concept living, kitchen and dining areas perfect for any gathering and plenty of natural light. The kitchen is well- equipped with ample space, modern cabinetry, island, gas range, up to date appliances and granite countertops. Find an additional living space upstairs! The primary bedroom includes an en-suite bathroom with separate shower, soaking tub and double sinks! Finally, step outside to a covered patio space and fully fenced large backyard, certain to meet your outdoor needs!','','11','','','','','Sellers Disclosure','','','','Aldine Area','Central Gas','1','LT 35 BLK 1 WESTVIEW LANDING SEC 1','Subdivision Lot','4950','Appraisal District','','550','0','','2','','0','','','','','Composition','1 - Aldine','CARTER ACADEMY','EISENHOWER HIGH SCHOOL','SHOTWELL MIDDLE SCHOOL','Lockbox Front','Appraisal District','2','Traditional','WESTVIEW LANDING','','','Public Sewer,Public Water,Water District','2017','Appraisal District'); --> New record created successfully