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-17T15:24:05.193' ,`MLSNumber` = '11811390' ,`ListAgentFullName` = 'Vicki Barazandeh' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765463' ,`Longitude` = '-95.419424' ,`PhotoCount` = '41' ,`PostalCode` = '77007' ,`RoomCount` = '7' ,`ListPrice` = '899900.00' ,`Status` = 'Active' ,`StreetName` = 'Malone' ,`StreetNumber` = '311' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two story maintenance free brick home within walking distance to Memorial Park and one block from the bike trail. The Victorian inspired home sits on a 3750 sq. ft. lot with a wrap around porch and yard. The elevation is graced with an expansive porch and large covered balcony and decorative rail detailing. The first floor living features expansive living room, dining room and kitchen with stone flooring, built-ins and beautiful millwork. The Primary suite opens to a large covered balcony, has a spacious primary bath with double sinks, whirlpool tub and two walk-in closets. The two additional bedrooms with wood flooring share a large hallway bath. The backyard includes a large storage shed. Seller is a custom homebuilder and can provide a small or large renovation.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 & N 1/2 OF LT 5 BLK 24 RICE MILITARY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rice Military/Washington Corridor' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213605' WHERE `Matrix_Unique_ID` = '207885527' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T16:40:56.750' ,`MLSNumber` = '16192869' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.941964' ,`Longitude` = '-95.204719' ,`PhotoCount` = '18' ,`PostalCode` = '77346' ,`RoomCount` = '10' ,`ListPrice` = '399990.00' ,`Status` = 'Active' ,`StreetName` = 'Davan Springs' ,`StreetNumber` = '15222' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2809' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 2-story home is CastleRock\'s Hayden Elevation \"A\" floor plan at 2,809 sqft. It\'s an open-concept Kitchen with gorgeous stainless steel appliances and Family Room with high ceilings. Has 5 bedrooms, 3 Bathrooms, Game Room, 2 car garage, and a Covered Patio! Also has other beautiful interior upgrades from the Design Gallery! Balmoral is known for its amazing amenities for all ages! The Crystal Clear Lagoon Beach Club yearly pass is only $300.00' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 41, Block 2, Section 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Colonial,Contemporary/Modern' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '3.083253' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213605' WHERE `Matrix_Unique_ID` = '209008179' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T16:48:37.090' ,`MLSNumber` = '18297940' ,`ListAgentFullName` = 'Maria Williams' ,`ListOfficeName` = 'Texcom Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.108479' ,`Longitude` = '-95.305982' ,`PhotoCount` = '40' ,`PostalCode` = '77365' ,`RoomCount` = '10' ,`ListPrice` = '549000.00' ,`Status` = 'Active' ,`StreetName` = 'Kolyma' ,`StreetNumber` = '19352' ,`StreetSuffix` = '' ,`City` = 'Porter' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3580' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity in Riverwalk within a short walk distance from community lake park.\r\n The home has 5 bedrooms and 4.5 bathrooms, with two primary bedrooms, 2 of the bedrooms are downstairs; this home has recently upgraded the AC units, all ducts, and also Appliances. The home also has a central vacuum system. The seller is in the process of building the 2-car garage.' ,`Acres` = '1.1' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERWALK 03, BLOCK 8, LOT 32, ACRES 1.100' ,`LotDesciption` = 'Wooded' ,`LotSize` = '47916' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'SORTERS MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverwalk 03' ,`TaxAmount` = '7112' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675213605' WHERE `Matrix_Unique_ID` = '209897726' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T15:09:58.997' ,`MLSNumber` = '10114335' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.368292' ,`Longitude` = '-95.670677' ,`PhotoCount` = '6' ,`PostalCode` = '77316' ,`RoomCount` = '9' ,`ListPrice` = '399990.00' ,`Status` = 'Active' ,`StreetName` = 'Tilia Creek' ,`StreetNumber` = '1246' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The well-designed Yuma plan includes four bedrooms, three bathrooms, and an upstairs gameroom!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14, Block 2, Section 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fairwater' ,`TaxAmount` = '' ,`TaxRate` = '2.58' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213606' WHERE `Matrix_Unique_ID` = '210160988' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T16:13:42.803' ,`MLSNumber` = '38087374' ,`ListAgentFullName` = 'John Nguyen' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.548838' ,`Longitude` = '-95.717434' ,`PhotoCount` = '50' ,`PostalCode` = '77469' ,`RoomCount` = '11' ,`ListPrice` = '2499999.00' ,`Status` = 'Active' ,`StreetName` = 'Alexandra Way' ,`StreetNumber` = '30' ,`StreetSuffix` = 'Circle' ,`City` = 'Richmond' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6341' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impeccable and chic, this new-construction abode offers contemporary living and a life of leisure on a 19,000-sq ft+ lot in the gated Lakes of Williams Ranch community. You\'ll arrive to find a nicely paved driveway lined by well-kept landscaping, adding tremendous curb appeal. The only modern home in this desirable area, the residence bursts with luxurious finishes and on-trend features that ensure the utmost convenience and comfort. Encompassing 6,500 sq ft are 5 bedrooms, 5 full baths, 2 half baths, 3 living areas, and 2 full kitchens. Venture inside to find an eye-catching foyer that showcases shiny custom tile flooring, floating ceilings, and a floating staircase, gorgeously lit by natural sunlight streaming in through an abundance of windows. \r\nSo much more to share and not enough characters to type out. Schedule your showing today before this heavenly gem is gone!' ,`Acres` = '0.4569' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ESTATES AT LAKES OF WILLIAMS RANCH SEC 1, BLOCK 2, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19740' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3465' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Estates At Lakes Of Williams Ranch Sec 1' ,`TaxAmount` = '29029' ,`TaxRate` = '2.6448' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213606' WHERE `Matrix_Unique_ID` = '210166395' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T15:10:54.593' ,`MLSNumber` = '36085337' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.368316' ,`Longitude` = '-95.669591' ,`PhotoCount` = '6' ,`PostalCode` = '77316' ,`RoomCount` = '9' ,`ListPrice` = '428990.00' ,`Status` = 'Active' ,`StreetName` = 'Tilia Creek' ,`StreetNumber` = '1218' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The well-designed Yuma plan includes four bedrooms, three bathrooms, and an upstairs gameroom!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20, Block 2, Section 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fairwater' ,`TaxAmount` = '' ,`TaxRate` = '2.58' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213606' WHERE `Matrix_Unique_ID` = '210298114' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T15:33:22.067' ,`MLSNumber` = '54599608' ,`ListAgentFullName` = 'Jon Kraft' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.388228' ,`Longitude` = '-95.598116' ,`PhotoCount` = '26' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Shadyside' ,`StreetNumber` = '11306' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful 3 bedroom 2.5 bath family home within walking distance to Lake Conroe. Neighborhood swimming pool just beyond the back yard. Huge living room with beautiful hardwood floor. Great kitchen with granite counter tops, large breakfast area, & stainless steel appliances. Spacious master suite w/double sinks and separate tub/shower. Located on a quiet cul-de-sac lot surrounded by beautiful trees in highly sought after Walden community with many amenities. Recent roof and A/C replacement. Montgomery ISD! Move-in ready!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 05, BLOCK 39, LOT 46' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '4742' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'WALDEN' ,`TaxAmount` = '4630' ,`TaxRate` = '2.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213606' WHERE `Matrix_Unique_ID` = '210851932' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T15:15:38.910' ,`MLSNumber` = '26925386' ,`ListAgentFullName` = 'Teresa Bruton' ,`ListOfficeName` = 'Rapid Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.615523' ,`Longitude` = '-95.073106' ,`PhotoCount` = '13' ,`PostalCode` = '77331' ,`RoomCount` = '10' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Southwood Shores' ,`StreetNumber` = '710' ,`StreetSuffix` = 'Drive' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Water view home located in the much desired subdivision of Southwood Shores. This one story home offers an open concept, 3 bedrooms and 2 baths along with spacious covered front and back porches. All custom cabinetry and newly painted interior. Carpet is a light tan color in all rooms. (Pics do not show true color) Enjoy easy access to Lake Livingston with a private community boat ramp and fishing pier. Very low HOA fee/taxes. Make this your permanent residence or a weekend getaway. Only an hour north of the Woodlands. Book your appointment now!\r\nNo garage or carport but room to build.' ,`Acres` = '0.35' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Southwood Shores, Lot 81' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '15246' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Southwood Shores' ,`TaxAmount` = '3551' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213606' WHERE `Matrix_Unique_ID` = '211047124' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T15:28:00.513' ,`MLSNumber` = '51202771' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Sylvia Hilmy' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.402493' ,`Longitude` = '-95.068751' ,`PhotoCount` = '28' ,`PostalCode` = '77568' ,`RoomCount` = '16' ,`ListPrice` = '474752.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lierna' ,`StreetNumber` = '2218' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3138' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Albany, Elevation F) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, study and formal dining room. Spacious island kitchen open to family room. Primary suite with large walk-in closet. Three additional bedrooms, spacious game room and media room on second floor. Covered patio and attached 2-car garage. Representing a prime location off I-45 South in the Galveston-Clear Lake corridor, you’ll find Lago Mar and its resort style living! Bay Area breezes will caress you while you lounge on white-sand beaches, swim in Caribbean-blue waters or dine lagoon-side on our beach boardwalk. Lago Mar includes 2 private resident gyms, 2 resident pools, playgrounds and acres of outdoor space. It’s an unparalleled standard of living where life is truly a breeze! Stop by the Westin Homes model home today to find out more about Lago Mar!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 14 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6240' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1404' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213607' WHERE `Matrix_Unique_ID` = '211230758' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T15:24:39.670' ,`MLSNumber` = '3758924' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Dena Day' ,`SellingOfficeName` = 'RE/MAX Fine Properties' ,`Latitude` = '29.681740' ,`Longitude` = '-95.836917' ,`PhotoCount` = '24' ,`PostalCode` = '77406' ,`RoomCount` = '16' ,`ListPrice` = '554547.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Rigel Ridge' ,`StreetNumber` = '10534' ,`StreetSuffix` = 'Way' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Albany, Elevation H) CURRENLTY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, study and formal dining room. Spacious island kitchen open to family room. Primary suite with large walk-in closet. Three additional bedrooms, spacious game room and media room on second floor. Covered patio and attached 2-car garage. Candela offers new homes for sale in Richmond, Texas. The community is the perfect combination of small-town charm and easy access to big city conveniences. Take a stroll through Downtown Historic Richmond, visit the Imperial Farmer\'s Market and enjoy the great outdoors at Brazos Bend State Park. Major employers in Houston, Katy and Sugar Land are only a short commute away. Great restaurants, and local and big box retail offerings are all close by. Visit Candela today to find your new home!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 43 BLK 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7118' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.15' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213607' WHERE `Matrix_Unique_ID` = '211231882' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T15:21:18.933' ,`MLSNumber` = '63375402' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Ogheneovo Okotie' ,`SellingOfficeName` = 'Prime Focus Realty' ,`Latitude` = '30.202611' ,`Longitude` = '-95.336437' ,`PhotoCount` = '27' ,`PostalCode` = '77302' ,`RoomCount` = '17' ,`ListPrice` = '629918.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Berry Brook' ,`StreetNumber` = '15084' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Asher V, Elevation A) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Elegant double front door entry, family room, informal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Attached 3-car tandem garage. Artavia, a master-planned community, will thrill you with endless possibilities just minutes from your home in Conroe, Texas. You’ll enjoy wide, outdoor spaces great for an active lifestyle and its convenient location. Onsite school is currently under construction! Stop by the Westin Homes model home today to find out more about Artavia!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 1, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10128' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '985' ,`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` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213607' WHERE `Matrix_Unique_ID` = '211265501' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T16:24:25.430' ,`MLSNumber` = '14516732' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.482381' ,`Longitude` = '-95.467254' ,`PhotoCount` = '37' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '314400.00' ,`Status` = 'Active' ,`StreetName` = 'Marvista' ,`StreetNumber` = '1238' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to Glendale Lakes! This Belle Vue floor plan offers 4 spacious Bedrooms and 3.5 Bathrooms. This open design floor plan is ready for May move-in! A modern Kitchen featuring 42’’ shaker Kitchen flat panel cabinetry, Quartz countertops with ceramic tile backsplash, high quality Frigidaire appliances and Kitchen island. This floor plan only has a garden tub in the primary bath. Energy efficiency features: 16 SEER carrier AC system with programmable thermostat, 40 gallon gas water heater. Full sod front and back landscape package included, Rear Patio, Brick fronts with stone accents per elevation and many more. If you are looking for a great community with easy access to outstanding shopping, dining, and majors freeways, in one of the best school districts, look no further! Set up your appointment today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 2 Section GL-9 Glendale Lakes' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5507' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213607' WHERE `Matrix_Unique_ID` = '211324088' --> 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','212074600','1675213608','212074600','2023-01-17T15:35:13.913','64023874','Thomas Johnson','RE/MAX GO','Deb Ambrosi','Ambrosi Realty INC.','29.533746','-95.912239','26','77471','4','269000.00','Pending Continue to Show','Randon School','6303','Road','Rosenberg','2','0','2','1553','Single-Family','Welcome to the country! Beautiful custom built home nestled on a one acre tree shaded lot. New interior paint and carpet. Fabulous open floor plan perfect for entertaining. Expansive great room with high ceilings and fireplace opens to the dining and kitchen. The dining could serve as a second living area or home office. The kitchen features a workspace/desk and a large walk in pantry. Spacious primary suite with en-suite bath and 3 closets. Large patio to relax and unwind at the end of a busy day or entertain guests. Room for a sparkling pool. Oversized garage with workbench and sink. Storage building. Country living convenient to I-69/US-59 and shopping and dining. Homes on one acre in the country are a rare find in Fort Bend County. Low taxes. No HOA. Call today for your showing!','1','30','J. Meyer','','','','Other Disclosures,Sellers Disclosure','1','Wood Burning Fireplace','1','','Propane','0','TODES S/D, BLOCK 2, LOT A, ACRES 1','Cleared','','Appraisal District','','','0','','2','Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','33 - Lamar Consolidated','BEASLEY ELEMENTARY SCHOOL (LAMAR)','TERRY HIGH SCHOOL','NAVARRO/GEORGE JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Todes Sub','3030','1.7948','Aerobic,Well','1987','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T16:50:51.200' ,`MLSNumber` = '30260280' ,`ListAgentFullName` = 'Maleeha Farooq' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.135867' ,`Longitude` = '-95.489228' ,`PhotoCount` = '29' ,`PostalCode` = '77380' ,`RoomCount` = '4' ,`ListPrice` = '332000.00' ,`Status` = 'Active' ,`StreetName` = 'Glen Loch' ,`StreetNumber` = '25507' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2242' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home is READY TO MOVE IN! This one story home is nestled in the heart of Timber Lakes with excellent schools and amenities near by. This home offers detailed thoughts to every finish in the house. The main components such as HVAC, and roof is brand new and many more to the list. Grand primary bedroom with great space and spa like bathroom. Open concept living room and kitchen (include soft close cabinets) with large windows allows the home to feel soothing and airy. House contains large backyard space that is perfect for hosting. The location is perfect, just minutes away from The Woodlands Mall, Easy access to 45 and Toll Roads.' ,`Acres` = '0.2583' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TIMBER LAKES 01, LOT 152' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAM HAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Lakes' ,`TaxAmount` = '4633' ,`TaxRate` = '2.5954' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213608' WHERE `Matrix_Unique_ID` = '212233160' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T16:24:50.513' ,`MLSNumber` = '20562834' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.482382' ,`Longitude` = '-95.467302' ,`PhotoCount` = '7' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '304700.00' ,`Status` = 'Active' ,`StreetName` = 'Escondido' ,`StreetNumber` = '6831' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1645' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to Glendale Lakes! This Cooper floor plan offers 3 spacious Bedrooms and 2 Bathrooms. This open design floor plan is ready for April move-in! A modern Kitchen featuring 42’’ shaker Kitchen flat panel cabinetry, Quartz countertops with ceramic tile backsplash, high quality Frigidaire appliances and Kitchen island. Relaxing bathrooms with double sinks, separate tub and shower in the Primary Bath, ceramic tile surround with tub in Secondary Baths and Quartz countertops. Energy efficiency features: 16 SEER carrier AC system with programmable thermostat, 40 gallon gas water heater. Full sod front and back landscape package included, Rear Patio, Brick fronts with stone accents per elevation and many more. If you are looking for a great community with walking trail, easy access to majors freeways, in one of the best school districts, this is it! Set up your appointment today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 3 Section GL-9 Glendale Lakes' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213608' WHERE `Matrix_Unique_ID` = '212317426' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T15:16:56.860' ,`MLSNumber` = '92611245' ,`ListAgentFullName` = 'Gary Helmcamp' ,`ListOfficeName` = 'Tri-County Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.694971' ,`Longitude` = '-96.776873' ,`PhotoCount` = '14' ,`PostalCode` = '78962' ,`RoomCount` = '2' ,`ListPrice` = '299500.00' ,`Status` = 'Active' ,`StreetName` = 'Eagle' ,`StreetNumber` = '704' ,`StreetSuffix` = 'Street' ,`City` = 'Weimar' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 0.2992 acre lot is in a prime location just north of I-10 Exit 682 with great visibility featuring approx. 100\' of FM 155 (Eagle St) frontage connecting I-10 to Hwy 90 with 4,191 Annual Average Daily Traffic (AADT), per TxDOT. The property features a 2BR/1.5BA home with masonite siding & stone wains-coating exterior, metal roof, newer windows, limestone gravel driveway, approx. 770 sqft detached apartment & fenced backyard. The detached apartment includes (7) single rooms & (2) bathrooms. The apartment is currently leased & generating rental income. Zoned Commercial 1- General retail without manufacturing. The property is centrally located between Houston (88 miles), San Antonio (110 miles), Austin (79 miles) & Victoria (71 miles). Several businesses are located nearby.' ,`Acres` = '0.2992' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A-364 R JOHNSON BLK 111 WEIMAR .2992 AC HOUSE & BLDG' ,`LotDesciption` = 'Other' ,`LotSize` = '13033' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '203 - Weimar' ,`SchoolElementary` = 'WEIMAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEIMAR HIGH SCHOOL' ,`SchoolMiddle` = 'WEIMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'N/A' ,`TaxAmount` = '2975' ,`TaxRate` = '1.917981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213608' WHERE `Matrix_Unique_ID` = '212563562' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T16:18:02.040' ,`MLSNumber` = '14649414' ,`ListAgentFullName` = 'Cesar Ramirez' ,`ListOfficeName` = 'Vylla Home' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.439739' ,`Longitude` = '-95.442037' ,`PhotoCount` = '22' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Onyx Trail' ,`StreetNumber` = '9915' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2382' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a look at this 4 bedroom 2.5 bathroom home located in Sterling Lakes At Iowa Colony. Gated community with many lakes and amenities. This home features formal dining area, downstairs primary bedroom. 3 bedrooms and a gameroom upstairs. This home is priced to sell and will not last long. Schedule your personal tour today.' ,`Acres` = '0.1162' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Real Estate Owned' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING LAKES AT IOWA COLONY SEC 2 (A0289 HT&B) BLK 1 LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5062' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Lakes At Iowa Colony' ,`TaxAmount` = '8883' ,`TaxRate` = '3.4099' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213608' WHERE `Matrix_Unique_ID` = '212704445' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T16:57:29.007' ,`MLSNumber` = '43348859' ,`ListAgentFullName` = 'Anhmai Dang' ,`ListOfficeName` = 'Gisela Duverney Properties,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.915362' ,`Longitude` = '-95.674627' ,`PhotoCount` = '38' ,`PostalCode` = '77095' ,`RoomCount` = '9' ,`ListPrice` = '326000.00' ,`Status` = 'Active' ,`StreetName` = 'Bark Ridge' ,`StreetNumber` = '9715' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2311' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FRESHLY NEW PAINT ( ALL INSIDE & OUTSIDE), NEWLY INSTALLED WOOD-BASED LAMINATED FLOORING (Dining & Family room), NEW CARPET, READY TO MOVE IN. A MUST SEE. \r\nThis beautiful house is very well maintained, at the end of the cul-de-sac of Deaton Mills section. Enjoy a fun and active lifestyle in Canyon Lakes at Stonegate close to dining, shopping & the upscale Boardwalk at Towne Lake. The community amenities include splash pad, pools, tennis courts, basketball court and close to Houston National Golf Club.\r\n1st floor, Primary Suite boasts a spa-like en-suite bath with jetted tub, separate walk-in shower, and a double sink with makeup vanity. Other 3 bedrooms are upstairs with a game room. which can convert to an office or a computer room. The kitchen has granite countertop, beautiful mahogany color cabinets with under lighting and many more.' ,`Acres` = '0.1159' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 40 BLK 1 CANYON LAKES AT STONEGATE SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5047' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '940' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Lks/Stonegate Sec 04' ,`TaxAmount` = '5643' ,`TaxRate` = '2.561' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213609' WHERE `Matrix_Unique_ID` = '212882830' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T16:10:26.577' ,`MLSNumber` = '28260056' ,`ListAgentFullName` = 'Jenny Zhang' ,`ListOfficeName` = 'AlphaMax Realty Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.565729' ,`Longitude` = '-95.694594' ,`PhotoCount` = '40' ,`PostalCode` = '77479' ,`RoomCount` = '11' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Brook Arbor' ,`StreetNumber` = '3206' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '3734' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this lovely two story house nested in a quite community! High ceilings, Tons of natural lights, formal living and Formal dining, Extra bedroom/office downstairs with full bath. master bedroom with sitting area downstairs and large bathroom, Kitchen features tile floor, lots of cabinets, Laminated flooring in all living area, carpet in bedrooms, Detached two car garage with extension for additional storage space. Large patio for every relaxing moments!' ,`Acres` = '0.2094' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERPARK SEC 12, BLOCK 1, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9123' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '845' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverpark Sec 12' ,`TaxAmount` = '8638' ,`TaxRate` = '2.6977' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213609' WHERE `Matrix_Unique_ID` = '213155540' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T15:22:33.280' ,`MLSNumber` = '4377873' ,`ListAgentFullName` = 'Suzanne Estrada' ,`ListOfficeName` = 'Leopold & Strahan Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.468085' ,`Longitude` = '-94.598010' ,`PhotoCount` = '26' ,`PostalCode` = '77650' ,`RoomCount` = '6' ,`ListPrice` = '1076500.00' ,`Status` = 'Active' ,`StreetName` = 'Tradewind' ,`StreetNumber` = '2789' ,`StreetSuffix` = 'Lane' ,`City` = 'Crystal Beach' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2024' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 bed/3.5 bath home with breathtaking unobstructed views of the beach. NO HOA! Take in the warm ocean breeze from the expansive balcony overlooking the waves or venture out for an easy stroll on the sand steps away from your front door. Open concept kitchen includes marble countertops with subway tile backsplash, an island with breakfast bar, picture frame cabinets & stainless appliances. Modern fixtures & recessed lighting. The living room provides a comfortable space to relax - warm tones, crown molding and views of the beach. 3 spacious guestrooms, one with a built in trundle, perfect as a mother-in-law suite & a Jack-n-Jill bath. Upstairs the 4th bedroom is tucked away with a private balcony overlooking the beach. Outdoor entertainment space with a bar area and an enclosed outdoor shower. The beach is your front yard. MAKE AN OFFER TODAY!' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 13 BLK 8 TIDELANDS ADDN' ,`LotDesciption` = 'Water View' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Tidelands' ,`TaxAmount` = '10480' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213609' WHERE `Matrix_Unique_ID` = '213266265' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T15:21:10.697' ,`MLSNumber` = '22259964' ,`ListAgentFullName` = 'Jessica Pico' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = 'Dylon Martinez' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.860569' ,`Longitude` = '-95.735104' ,`PhotoCount` = '39' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '292999.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Marigold Meadow' ,`StreetNumber` = '20715' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UPGRADED HOME & JUST AS NEW! UNIQUE 3bed / 2 bath. In the heart of Katy @ Jasmine Heights! As you walk in you will feel that you are at home! The new porcelain floors will take you breath away along with several upgrades throughout the home such as baseboards moulding, sinks, water faucets, mirrors, floors, counter tops and more. This open concept floor plan features a beautiful kitchen with double sinks and a kitchen island, granite counter tops and backsplash that connects to the formal dinning and living room area making it perfect for your family gatherings. Home features primary bedroom with large bathroom with separate shower & tub and granite counter tops. Great backyard space and covered patio.You have to make an appointment to see this home with additional upgrades that you cannot find in this neighborhood.' ,`Acres` = '0.1333' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 44 BLK 7 JASMINE HEIGHTS SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5807' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights Sec 9' ,`TaxAmount` = '6025' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213609' WHERE `Matrix_Unique_ID` = '213941980' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T15:07:08.117' ,`MLSNumber` = '86418750' ,`ListAgentFullName` = 'Travis Wilson' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.297452' ,`Longitude` = '-95.418378' ,`PhotoCount` = '29' ,`PostalCode` = '77301' ,`RoomCount` = '10' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Quarry Springs' ,`StreetNumber` = '3006' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2004' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. Situated on a corner lot, this lovingly maintained home awaits new owners. Over 2000+ square feet of living space with an ideal floor plan. The living room can be turned into an office, media or play room – the option is yours! A kitchen island with bar seating, granite countertops, and beautiful cabinetry are just a few kitchen features. The spacious family room is bursting with natural light and opens up to the kitchen with tile flooring. Relax in your own private oasis in the primary bedroom that has a bath en-suite with double sinks, garden tub, and large walk-in closet. The covered patio provides ample shade during the hot Texas summers and the private backyard is a blank slate for new owners. HWY 45, restaurants, and stores are located just down the road for your convenience. Welcome home!' ,`Acres` = '0.1675' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S646903 - LADERA CREEK 03, BLOCK 3, LOT 11' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7297' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RUNYAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ladera Creek 03' ,`TaxAmount` = '8381' ,`TaxRate` = '3.0863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213610' WHERE `Matrix_Unique_ID` = '214047226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T15:48:37.900' ,`MLSNumber` = '10800673' ,`ListAgentFullName` = 'Angela Talley' ,`ListOfficeName` = 'Key 2 Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.020368' ,`Longitude` = '-95.648606' ,`PhotoCount` = '49' ,`PostalCode` = '77429' ,`RoomCount` = '10' ,`ListPrice` = '374999.00' ,`Status` = 'Active' ,`StreetName` = 'Vincennes Oak' ,`StreetNumber` = '15306' ,`StreetSuffix` = 'Street' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2114' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open layout with high ceilings. 3 car garage, fenced in 9x10 patio off master bedroom. Large kitchen with quartz countertops and custom cabinets, tile backsplash, 42 upper cabinets & island. Bay window in breakfast room. Tile floors in kitchen, entry, utility & all bathrooms, vinyl plank in family room, master bedroom and hallway. Standard vinyl windows, 3 sides brick, separate tub and shower in master bathroom, double sinks, rounded sheetrock corners. Quiet neighborhood nestled in a country like setting but just minutes from 99, 249 and 290. This home has been updated and is gorgeous don\'t miss the opportunity. A MUST SEE.......' ,`Acres` = '0.1567' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 3 GRANT MEADOWS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BLACK ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grant Mdws Sec 1' ,`TaxAmount` = '6562' ,`TaxRate` = '2.821' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213610' WHERE `Matrix_Unique_ID` = '214106610' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T16:25:45.970' ,`MLSNumber` = '85590459' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.482381' ,`Longitude` = '-95.467254' ,`PhotoCount` = '37' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '345400.00' ,`Status` = 'Active' ,`StreetName` = 'Mariquita' ,`StreetNumber` = '1226' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to Glendale Lakes! This Belle Vue floor plan offers 4 spacious Bedrooms and 3.5 Bathrooms. This open design floor plan is ready for August move-in! A modern Kitchen featuring 42’’ shaker Kitchen flat panel cabinetry, Quartz countertops with ceramic tile backsplash, high quality Frigidaire appliances and Kitchen island. This floor plan only has a garden tub in the primary bath. Energy efficiency features: 16 SEER carrier AC system with programmable thermostat, 40 gallon gas water heater. Full sod front and back landscape package included, Rear Patio, Brick fronts with stone accents per elevation and many more. If you are looking for a great community with easy access to outstanding shopping, dining, and majors freeways, in one of the best school districts, look no further! Set up your appointment today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Block 1 Section GL-9 Glendale Lakes' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5507' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213610' WHERE `Matrix_Unique_ID` = '214125177' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T15:12:43.493' ,`MLSNumber` = '39032255' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Lisa C. Niles' ,`SellingOfficeName` = 'Citizen-Niles Realty Group' ,`Latitude` = '29.571736' ,`Longitude` = '-95.738261' ,`PhotoCount` = '27' ,`PostalCode` = '77469' ,`RoomCount` = '18' ,`ListPrice` = '649714.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wilkinson' ,`StreetNumber` = '23418' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3693' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter VII, Elevation P) CURRENTLY BEING BUILT. Two story cul-de-sac lot. 5 bedrooms. 4.5 baths. Family room, formal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Extended covered rear patio and attached 2-car garage. Spanning nearly 600 acres of beautiful homes, lush landscaping, trails, and exciting amenities, Veranda embodies the legacy of historic Richmond with all the comforts of a luxurious master-planned community. Minutes to the newly expanded I-69 and the Grand Parkway, you are near exceptional shopping, dining and recreation. Stop by the Westin Homes model home today to find out more about Veranda!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 8 BLK 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8163' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213610' WHERE `Matrix_Unique_ID` = '214291920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T15:51:07.983' ,`MLSNumber` = '14761932' ,`ListAgentFullName` = 'Brandy Mayr' ,`ListOfficeName` = 'RE/MAX Universal Northwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.135044' ,`Longitude` = '-95.816043' ,`PhotoCount` = '46' ,`PostalCode` = '77447' ,`RoomCount` = '3' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Shoreline Rd' ,`StreetNumber` = '25373' ,`StreetSuffix` = '' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful NEW CONSTRUCTION, one story, 3 bedroom, 2 bath, 1,572 square foot home on a gorgeous 3/4 acre lakefront lot! Come home to the peace and tranquility of Lakeside Estates subdivison in beautiful/quiet Hockley, Texas. This BRAND NEW Freedom Star Home will have a spacious feel as you enter the foyer and into the open floor plan of the main living area and kitchen. Raised ceilings, recessed lighting and view of backyard/LAKE are more than eye catching! Granite countertops, stainless steel appliances, spacious primary bed/bath, garden tub, glass encased shower, his/her vanities. Large windows for abundant natural light throughout. 3 car garage & extended covered patio/porch to enjoy your LAKEFRONT LOT. Lake on the side of lot and behind lot!! Privacy fence with gated entrance!!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Freedom Star' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 163 SECTION 4' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '33782' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '252' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Lakeside Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213611' WHERE `Matrix_Unique_ID` = '214360413' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T16:25:12.837' ,`MLSNumber` = '79012313' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.482382' ,`Longitude` = '-95.467302' ,`PhotoCount` = '36' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '294700.00' ,`Status` = 'Active' ,`StreetName` = 'Mariquita' ,`StreetNumber` = '1215' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1645' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to Glendale Lakes! This Cooper floor plan offers 3 spacious Bedrooms and 2 Bathrooms. This open design floor plan is ready for April move-in! A modern Kitchen featuring 42’’ shaker Kitchen flat panel cabinetry, Quartz countertops with ceramic tile backsplash, high quality Frigidaire appliances and Kitchen island. Relaxing bathrooms with double sinks, separate tub and shower in the Primary Bath, ceramic tile surround with tub in Secondary Baths and Quartz countertops. Energy efficiency features: 16 SEER carrier AC system with programmable thermostat, 40 gallon gas water heater. Full sod front and back landscape package included, Rear Patio, Brick fronts with stone accents per elevation and many more. If you are looking for a great community with walking trail, easy access to majors freeways, in one of the best school districts, this is it! Set up your appointment today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 Block 2 Section GL-9 Glendale Lakes' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213611' WHERE `Matrix_Unique_ID` = '214484328' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T16:16:23.230' ,`MLSNumber` = '54298975' ,`ListAgentFullName` = 'David Montalvo' ,`ListOfficeName` = 'Homelister, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.656393' ,`Longitude` = '-95.452623' ,`PhotoCount` = '32' ,`PostalCode` = '77035' ,`RoomCount` = '9' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Spellman' ,`StreetNumber` = '4506' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enter House through inviting from Porch, into the Living Room, that flows into the Dining Room and Family Room. Kitchen is large with lots of storage and room for dining table. House has original hardwood floors in Bedrooms and Living Spaces. Main Drain to City Line install in 2022. New A/C, Heating, Duct, Vents, and Returns installed in 2019. All new Flex Pipe installed in 2019. New Electrical Box installed in 2019. Freshly painted garage with oversized pulldown Attic Ladder. Washer and Gas Dryer connecting in attached garage. Backyard features a 12\' x 20\' Morgan Storage building with extra wide door.' ,`Acres` = '0.1582' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 6 POST OAK MANOR SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6893' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Post Oak Manor Sec 02' ,`TaxAmount` = '6108' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213611' WHERE `Matrix_Unique_ID` = '214776218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T16:51:07.987' ,`MLSNumber` = '53981097' ,`ListAgentFullName` = 'Aaron Dvorak' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.976728' ,`Longitude` = '-95.496182' ,`PhotoCount` = '27' ,`PostalCode` = '77066' ,`RoomCount` = '9' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Wind Chimes' ,`StreetNumber` = '4806' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large 2 story home on quiet cul-de-sac lot. Back yard is nice and big, includes gas b-b-q grill on back patio. Klein ISD schools nearby. Home has 4 large bedrooms which all rooms are upstairs. Large family room with cozy fireplace over looking the large fenced in back yard.' ,`Acres` = '0.2113' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 15 FOUNTAINHEAD SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9205' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'GREENWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fountainhead Sec 02' ,`TaxAmount` = '5096' ,`TaxRate` = '2.6215' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213611' WHERE `Matrix_Unique_ID` = '214941709' --> 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','215142225','1675213612','215142225','2023-01-17T15:29:55.997','10560536','Nicole Fenwick','Oak Story Realty, LLC.','','','29.554997','-95.235135','27','77581','8','349500.00','Active','Washington Irving','1910','Drive','Pearland','2','0','4','2049','Single-Family','Beautiful one-story ranch style home in highly desirable Sleepy Hollow on an oversized lot (.396 acres). The home features an amazing backyard with a composite wood deck and beautiful shade trees - perfect for entertaining. The kitchen features attractive, granite countertops. The open floor plan with ample natural lighting enlarges the living area that features a corner fireplace, tile flooring, and large windows. Down the hallway, you will find the primary suite and three secondary bedrooms. The primary bedroom includes an en suite bathroom, built-in vanity, and walk in closet. NO HOA and quick access to l-45/ Beltway 8. Zoned to highly rated Pearland ISD schools. Make your appointment today!','','5','','','','','Sellers Disclosure','','','1','Pearland','Central Gas','0','SLEEPY HOLLOW (PEARLAND) BLK 12 LOT 4','Subdivision Lot','17250','Appraisal District','','','0','','0','','0','','','','','Composition','42 - Pearland','SHADYCREST ELEMENTARY SCHOOL','PEARLAND HIGH SCHOOL','PEARLAND JUNIOR HIGH EAST','Appointment Required','Appraisal District','1','Ranch','Sleepy Hollow Pearland','','','Public Sewer,Public Water','1967','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','215204196','1675213612','215204196','2023-01-17T16:32:48.187','61507478','Alexander Jaramillo','Realty ONE Group, Experience','','','30.391281','-95.617784','39','77356','4','344900.00','Active','Pine Chase','3138','Drive','Montgomery','2','0','3','2304','Single-Family','Beautiful home located in the highly sought-after Walden on Lake Conroe. The home features 3 Bedrooms, 2 Baths, 2 Car Garage with Greenbelt directly behind the home. Inside you\'ll find a spacious Living Area with Built-ins, Wood Burning Fireplace, a Cove Ceiling, & French Doors leading to 1 of 2 patios. New Luxury Vinyl Plank flooring in all bedrooms and hallway. Ceramic Tile Flooring in main Living areas, spacious Formal Dining Room. The Kitchen has abundance of Cabinet space, Granite Counter Tops, Stainless Steel Appliances. The primary bedroom has bay windows & an exterior door leading to the patio. Primary Bath features Granite Vanity with Double Sinks, Soaking Tub, Separate Shower, & a large Walk-In Closet. All new interior/exterior paint, new Ceiling Fans, new Light Fixtures, & a new Landscaped Front Yard. The Backyard is fenced, perfect for pets and kids & has a Sprinkler System. 2018 A/C system. Zoned to Montgomery Exemplary School District!','0.2066','39','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Lake Conroe Area','Central Electric','1','S945509 - WALDEN 09, BLOCK 49, LOT 20','In Golf Course Community,Subdivision Lot','9000','Appraisal District','','950','0','','2','','0','','','Electric Range','','Composition','37 - Montgomery','MADELEY RANCH ELEMENTARY SCHOOL','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Walden','7268','2.2242','Water District','2001','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','215227892','1675213612','215227892','2023-01-17T15:32:32.910','82075067','Robert Moore','Perry Homes Realty, LLC','','','30.292096','-95.560838','10','77316','8','679900.00','Active','Sweeping Valley','124','Drive','Montgomery','3','1','4','3481','Single-Family','PERRY HOMES NEW CONSTRUCTION! Home office with French doors and formal dining room frame extended entry with 13-foot coffered ceiling. Open family room features a wall of windows. Kitchen features a walk-in pantry and Butler\'s pantry. Game room with French doors adjoins the morning area. Spacious primary suite. Additional half bathroom. Primary bath includes corner garden tub, separate glass-enclosed shower, two sinks and two large walk-in closets. Guest suite with a full bath. Mud room with a linen closet. Extended covered backyard patio. Three-car garage.','','39','Perry Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Conroe Southwest','Central Gas','1','Lot 7, Block 1','Subdivision Lot','13457','Other','','1392','1','To Be Built/Under Construction','3','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Woodforest','','2.6868','Water District','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','215289369','1675213612','215289369','2023-01-17T16:59:08.950','65735527','Tammy Fruge','Westin Homes','Maria Irureta','REALM Real Estate Professional','29.750546','-95.877455','30','77494','15','549672.00','Pending Continue to Show','Lemonwood','2835','Lane','Katy','3','1','4','3000','Single-Family','Westin Homes NEW Construction (Ellicott, Elevation AP) CURRENTLY BEING BUILT. Two story. 4 bedrooms (2-downstairs). 3.5 baths. Grand foyer with winding staircase & rotunda ceiling. Study. Informal dining adjacent to modern kitchen & 2-story family room. Game room and media room upstairs. Covered patio and attached 2 car garage. Small Town. Big Amenities. At Jordan Ranch they are giving good old-fashioned fun a stylish upgrade! Whether you’re making new friends at The Hub or floating the day away in the Lazy River- there’s something for everyone. The Director of Fun has a wide range of activities on the calendar all year long, so you’re free to “live it up” to your heart’s content. Stop by the Westin Homes model home to find out more about Jordan Ranch.','','30','Westin Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Gas Connections','1','Katy - Southwest','Central Gas','1','LOT 8 BLK 1','Subdivision Lot','6085','Other','','1050','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','LINDSEY ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Jordan Ranch','','3.27','Water District','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','215332648','1675213612','215332648','2023-01-17T15:33:31.940','62066192','Robert Moore','Perry Homes Realty, LLC','','','30.291289','-95.560055','10','77316','8','839900.00','Active','Lassiter','212','Court','Montgomery','3','1','4','3300','Single-Family','PERRY HOMES NEW CONSTRUCTION! Home office with French doors set at entry with 12-foot ceiling. Extended entry leads to open family r