Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T12:54:30.097' ,`MLSNumber` = '18866826' ,`ListAgentFullName` = 'Crystal Herman' ,`ListOfficeName` = 'Southern Style Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.461438' ,`Longitude` = '-94.793722' ,`PhotoCount` = '25' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '140000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2146' ,`StreetNumber` = '208' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, quite country setting with an adorable free standing wood siding home that has much potential! Original home was built in 86\' and is set atop stilts to enjoy the wooded views. This portion includes a primary bedroom (laundry on this level), large living area with wood-burning fireplace with cute and sunny kitchen! Second bedroom on ground floor with stand-up shower was added in the 90\'s. The guest home includes one bedroom with stand-up handicap accessible shower, with living/kitchen combo and will convey with property (WILL NOT BE MOVED) A beautifully constructed covered porch and ramp make this space easy to navigate. *All appliances will stay.* Bring your pets, family and friends to enjoy the country life!' ,`Acres` = '0.855' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Electric,Other Heating,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'BAR-D-RANCHETTS, LOT 25-A, ACRES .855' ,`LotDesciption` = 'Cleared' ,`LotSize` = '37244' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '107 - Hardin' ,`SchoolElementary` = 'HARDIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN HIGH SCHOOL' ,`SchoolMiddle` = 'HARDIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Bar-D-Ranchetts' ,`TaxAmount` = '1190' ,`TaxRate` = '1.7656' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087974' WHERE `Matrix_Unique_ID` = '206035841' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T11:39:31.670' ,`MLSNumber` = '52609635' ,`ListAgentFullName` = 'Colby Walters' ,`ListOfficeName` = 'Swede\'s Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.452295' ,`Longitude` = '-94.632968' ,`PhotoCount` = '15' ,`PostalCode` = '77650' ,`RoomCount` = '3' ,`ListPrice` = '669000.00' ,`Status` = 'Active' ,`StreetName` = 'Redfish' ,`StreetNumber` = '1843' ,`StreetSuffix` = 'Lane' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1333' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3/2 second row beach house with county buyouts on first row. Breathtaking views of the Gulf from the deck and a forever unobstructed view! Beach access directly in the subdivision. Built in bunkbeds! Close to all restaurants, shops, and attractions Crystal Beach has to offer! This home will come fully furnished and turn key! Would make a great investment property or second home.' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOT 26 & E 1/2 LOT 25 BLK 2 BLALOCK SUB' ,`LotDesciption` = 'Water View' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Blalock' ,`TaxAmount` = '5195' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087975' WHERE `Matrix_Unique_ID` = '208454972' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T12:42:14.640' ,`MLSNumber` = '47128007' ,`ListAgentFullName` = 'Randy French' ,`ListOfficeName` = 'Stylecraft Builders, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.392282' ,`Longitude` = '-95.722234' ,`PhotoCount` = '39' ,`PostalCode` = '77356' ,`RoomCount` = '10' ,`ListPrice` = '312900.00' ,`Status` = 'Active' ,`StreetName` = 'Colby\'s Way' ,`StreetNumber` = '108' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1841' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Upon entering this exceptional floor plan, you\'re immediately greeted with a high ceiling foyer. Walking into the open-concept kitchen and living room, you\'ll be stunned by the amount of space you have to gather. This three bedroom, two bath home has placed windows in the living room, primary bedroom, and dining room, crafting a home that is filled with natural light and charm. Granite countertops throughout and a large walk-in primary closet to top it all off and make this home exceptional. Additional options included: Stainless steel appliances, under cabinet lighting, decorative tile backsplash, single basin kitchen sink, and painted cabinets throughout.' ,`Acres` = '0.262695' ,`Area` = '39' ,`BuilderName` = 'Stylecraft' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S582404 - The Hills Of Town Creek 04, BLOCK 1, Lot 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11443' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Hills of Towncreek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087975' WHERE `Matrix_Unique_ID` = '208837170' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T12:49:10.430' ,`MLSNumber` = '67728067' ,`ListAgentFullName` = 'Veronica Sanchez' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.374710' ,`Longitude` = '-94.762060' ,`PhotoCount` = '16' ,`PostalCode` = '77327' ,`RoomCount` = '3' ,`ListPrice` = '65000.00' ,`Status` = 'Active' ,`StreetName` = 'Highway 146' ,`StreetNumber` = '26055' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor Special!!! Property in need of TLC- Call agent.' ,`Acres` = '0.2' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = '000064 J D MARTINEZ-1, TRACT 71, ACRES .2' ,`LotDesciption` = 'Other' ,`LotSize` = '8712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '107 - Hardin' ,`SchoolElementary` = 'HARDIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN HIGH SCHOOL' ,`SchoolMiddle` = 'HARDIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'J D Martinez-1' ,`TaxAmount` = '828' ,`TaxRate` = '1.7656' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087975' WHERE `Matrix_Unique_ID` = '208916459' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T11:50:20.067' ,`MLSNumber` = '45564155' ,`ListAgentFullName` = 'Cody Victor' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.485197' ,`Longitude` = '-95.462269' ,`PhotoCount` = '33' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Montebello Court' ,`StreetNumber` = '626' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2013' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this breathtaking four bedroom- two bathroom home. Once arriving you\'ll be greeted by a double wide driveway and a two car garage. Upon entering the home you\'ll be enamored by the natural lighting, extended hallway, and stunning split floor plan. The kitchen contains stainless steel appliances and an island that can hold a plethora of dishes for gatherings. This home has an extra wide dining and great room area- a decorator\'s dream. The primary suite has an oversized room for a huge bed and space for a seating area to read, surf the web, or work. The suite is also equipped with separate vanities, separate shower and bathtub, and a walk in closet. Enjoy your tour!\r\n\r\n\r\n\r\n\r\nQR Code contains a 3D tour and a video.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Saratoga' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GLENDALE LAKES SEC 5, BLOCK 2, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5093' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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,Lockbox Back,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.1129' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087975' WHERE `Matrix_Unique_ID` = '210109359' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T11:23:38.507' ,`MLSNumber` = '17157400' ,`ListAgentFullName` = 'Carla Rae Southard' ,`ListOfficeName` = 'The Virtual Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.799146' ,`Longitude` = '-95.658968' ,`PhotoCount` = '32' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '329862.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 297' ,`StreetNumber` = '1916' ,`StreetSuffix` = '' ,`City` = 'Sargent' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '878' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCED!!!!! Your dream home is right here on Caney Creek!!Recently remodeled and fresh interior and exterior paint, This home has so many unique features....Let\'s start inside! This home is 2 Bedrooms one bath and the interior is amazing!! Custom Cabinetry, Granite Counter tops and windowsills, new flooring, new Ductless HVAC system, Vinyl Windows, ALL NEW STAINLESS Appliances and a totally Spa like bathroom!! Now let\'s talk about the outside!! This lot is totally bulkheaded, and the most amazing covered outdoor kitchen area in town! Wired and ready for you to customize, this is where all the fun will be for family and friends!!! The breezy shady front Porch is made for some Rocking Chairs or even a hammock! This one is ready to start enjoying Sargent Life!!!! Neighborhood Boat ramps, Bait Camps and Sargent Beach Minutes away!!' ,`Acres` = '0.432' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'CANEY CREEK ESTATES SEC 1, LOT 122' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '18818' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '60' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Caney Creek Estates Sec 1' ,`TaxAmount` = '3637' ,`TaxRate` = '2.3895' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675087976' WHERE `Matrix_Unique_ID` = '210470884' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T12:46:07.260' ,`MLSNumber` = '59750073' ,`ListAgentFullName` = 'Elizabeth Minjarez' ,`ListOfficeName` = 'Elite Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.191745' ,`Longitude` = '-95.727272' ,`PhotoCount` = '25' ,`PostalCode` = '77355' ,`RoomCount` = '7' ,`ListPrice` = '274999.00' ,`Status` = 'Active' ,`StreetName` = 'Roadie' ,`StreetNumber` = '30802' ,`StreetSuffix` = 'Pass' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1657' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 story home with a great open concept floor plan with 3 bedrooms 2 full baths with a library/office suite (optional 4th bedroom). Faux ceramic wood floors throughout with neutral paint colors. High ceilings. Granite countertops in kitchen. Huge backyard. Washer/Dryer/Fridge stay. This property is conveniently tucked away in the quite community of Lakes of Magnolia where the city meets country. Zoned to MISD schools, 2 entrances to the subdivision off 1774 close to baseball fields, new HEB and Tomball Expressway. Home is walking distance to the neighborhood park and lake. Lawn has been digitally enhanced.' ,`Acres` = '0.1631' ,`Area` = '15' ,`BuilderName` = 'LGI' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S666100 - LAKES OF MAGNOLIA, BLOCK 5, LOT 68' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7104' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Of Magnolia' ,`TaxAmount` = '3282' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087976' WHERE `Matrix_Unique_ID` = '210656847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T12:42:33.127' ,`MLSNumber` = '73765298' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Christopher Gant' ,`SellingOfficeName` = 'Premier, Realtors' ,`Latitude` = '30.203272' ,`Longitude` = '-95.336757' ,`PhotoCount` = '36' ,`PostalCode` = '77302' ,`RoomCount` = '16' ,`ListPrice` = '609857.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Misty Brook' ,`StreetNumber` = '17798' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3625' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Hopkins, Elevation B) CURRENTLY BEING BUILT. Two Story. 4 bedrooms with Primary bedroom on first floor, 3.5 baths. Elegant double front door entry. Family Room, Formal Dining Room, and Living Room/Study. Game Room and Media Room upstairs. Extended covered rear patio and attached 2 car 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` = 'LOT 4 BLK 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7530' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '985' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`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` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087976' WHERE `Matrix_Unique_ID` = '210959126' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T12:40:46.753' ,`MLSNumber` = '15452297' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.154133' ,`Longitude` = '-95.584342' ,`PhotoCount` = '28' ,`PostalCode` = '77354' ,`RoomCount` = '17' ,`ListPrice` = '657842.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Davis Hill' ,`StreetNumber` = '27118' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`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. \r\n NorthGrove offers easy access to all the conveniences and necessities of modern living with The Woodlands, Tomball, and Conroe all a short distance away. With resort-style amenities, including The Retreat, a 9,400-sq.-ft. clubhouse, Northgrove is the perfect escape from the daily grind. Enjoy a fitness center, pool, children\'s play areas and more. Stop by the Westin Homes model home today to find out more about Northgrove!' ,`Acres` = '0.2214' ,`Area` = '15' ,`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` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 1, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9646' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northgrove' ,`TaxAmount` = '2250' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087976' WHERE `Matrix_Unique_ID` = '211266352' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T12:19:13.770' ,`MLSNumber` = '73418393' ,`ListAgentFullName` = 'Stanley Mani' ,`ListOfficeName` = 'MIH REALTY, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.524544' ,`Longitude` = '-95.550851' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '13' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Pointed Leaf' ,`StreetNumber` = '5402' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3552' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully young maintained energy-efficient Meritage home nestled on a large corner cul de sac lot in the GATED Pecan Estates of Anderson Springs Community in Sienna Plantation. Located minutes from Highway 6, this home features a great Open floorplan with 5 bedrooms, 3.5 baths, 3 car side entrance garage, formal dining, a large family room, office/study, soaring ceilings, spacious kitchen equipped with an island, Xtra long driveway, breakfast area, media, and a game room. The Primary bedroom and secondary bedrooms are comfortable and cozy, nicely sized for furniture of your choice! Primary bath has double sinks and vanities with a relaxing garden/soaking tub and stand-alone shower. Wood floors throughout the 1st floor with a carpeted second story. Then take a step outside to the gorgeous backyard with a garden already set up and planted fruit trees to watch mature throughout the years and memories in this home. Zoned to top-ranked Ft. Bend ISD schools. Schedule a tour today!' ,`Acres` = '0.3378' ,`Area` = '38' ,`BuilderName` = 'Meritage' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PECAN ESTATES AT ANDERSON SPRINGS SEC 2, BLOCK 2, LOT 8' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '14716' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2045' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SCHIFF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'SIENNA' ,`TaxAmount` = '11688' ,`TaxRate` = '2.8129' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087976' WHERE `Matrix_Unique_ID` = '211766236' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T12:47:32.230' ,`MLSNumber` = '27561102' ,`ListAgentFullName` = 'Vincent Miranda' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.265619' ,`Longitude` = '-94.839788' ,`PhotoCount` = '39' ,`PostalCode` = '77551' ,`RoomCount` = '6' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Dansby' ,`StreetNumber` = '48' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a beautiful corner property in the sought out, Colony Park subdivision in Galveston. As you enter this home, you walk into a very spacious living area which includes a wood burning fireplace, laminate flooring throughout and recessed lighting. The kitchen has ceramic tile throughout with black, granite countertops, custom built cabinets reaching the ceiling and stainless steel appliances. On one side of the kitchen is a breakfast area with bar top seating and on the other side is a formal dining room. The primary bedroom has a walk in closet and a primary bathroom with a walk in shower. All three bedrooms are on one side of the home. As you walk out the back of the home, there is a covered patio leading you into the back yard. Once you see this home, you will fall in love with it. Call today to book your showing!!!' ,`Acres` = '0.2134' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 20 BLK 6 COLONY PARK SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9294' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Colony Park 2' ,`TaxAmount` = '5994' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087977' WHERE `Matrix_Unique_ID` = '214514744' --> 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','214570743','1675087977','214570743','2022-12-06T12:58:33.077','93780573','Sonia Maredia','Compass RE Texas, LLC','','','29.782771','-95.492642','34','77024','20','2650000.00','Active','Hunters Creek','8447','Drive','Houston','5','1','5','5373','Single-Family','This show-stopping new construction in coveted Hunters Creek Village is a contemporary masterpiece featuring swoon-worthy details perfectly balanced with functionality. The stately family home is also an entertainer\'s dream come true w/ soaring 24\' high coffered ceilings, bespoke wine closet to showcase your finest collection & floor-to-ceiling windows w/ a full sliding glass door system for seamless indoor/outdoor living. The gourmet kitchen takes the cake offering bucket list essentials like a walk-in butler\'s pantry, statement waterfall island, premium Viking appliance package & built-in coffee bar system. Enjoy 2 ensuite bedrooms down including the primary, which rivals a 5-star luxury hotel. The powder room, office, formal dining & mudroom leading to the 2-car garage round out the 1st floor, while 3 oversized secondary rooms w/ ensuite baths, a game room w/ wet bar & media room complete the 2nd floor. Note, digitally rendered photos are subject to change per builder\'s discretion.','','23','Memorial Custom Home','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','Gas Connections','1','Memorial Villages','Central Gas','0','LT 2 BLK 1 INVERNESS','Subdivision Lot','12500','Survey','','','1','To Be Built/Under Construction','2','Convection Oven,Double Oven,Electric Oven','0','','','Gas Range','','Composition','49 - Spring Branch','HUNTERS CREEK ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (SPRING BRANCH)','SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)','Accompany,Appointment Required','Builder','2','Contemporary/Modern','Inverness','19862','2.111','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T12:00:40.367' ,`MLSNumber` = '63549217' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.469778' ,`Longitude` = '-95.525348' ,`PhotoCount` = '10' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '519000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingston Spring' ,`StreetNumber` = '10630' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2989' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to Newmark Homes Artisan Series in Sienna’s newest section of Heritage Park! The VERONA plan has it all! Modern Stucco/Brick elevation. Elevation 5, swing left. 5 bedroom 4 baths, flexible study/living. Dramatic family room with cathedral style windows. Open kitchen with large island. Huge game room and media room. Luxury porcelain countertops in kitchen, Hardwood floors in main area. Extended covered patio perfect for outdoor cooking and entertainment. Newmark Energy efficiency standards include- Open spray foam insulation, tankless water heater, full sod, full irrigation and full gutters! Estimated completion – February 2023' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 3 Section 48 Sienna' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Sienna 50\'' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087977' WHERE `Matrix_Unique_ID` = '214889999' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-06T12:00:25.017' ,`MLSNumber` = '47603905' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.469582' ,`Longitude` = '-95.525313' ,`PhotoCount` = '10' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '549000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingston Spring' ,`StreetNumber` = '10634' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3247' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newmark Homes -LINZ Plan in Sienna’s newest section. Popular front porch elevation. 5 bedroom (2 down with en-suite baths). Dramatic 2 story foyer and family room with cozy corner fireplace, wall of windows . Open kitchen with huge island and breakfast nook. Formal dining. Porcelain kitchen countertops, Hardwood floors in main areas. Elegant ,curved staircase takes you upstairs to huge game room and media room, 3 bedrooms and 2 baths up. 3 car tandem garage. Covered back patio for outdoor entertainment. Open spray foam insulation, Tankless water heater, Full Irrigation and Full Gutters are all included.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 3 Section 48 Sienna' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Sienna 50\'' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087977' WHERE `Matrix_Unique_ID` = '214890385' --> 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','215343004','1675087977','215343004','2022-12-06T11:18:22.943','18833845','Sergio De La Llata Jr.','Sierra Vista Realty LLC','','','29.731659','-95.282102','8','77012','4','100000.00','Active','Sherman','7931','Street','Houston','2','0','4','942','Single-Family','The possible opportunities that come with this project are endless. Investors, this one is calling your name. The exterior has been provided, but the inside has so many different possibilities to make this house into a home. Talk about great location! Schedule your private tour now! You don\'t want to miss out.','0.1148','4','','','','','Sellers Disclosure','','','','East End Revitalized','No Heating','0','LTS 7 & 8 BLK 22 MAGNOLIA PARK SEC 2','Subdivision Lot','5000','Appraisal District','','','0','','0','','0','','','','','Composition,Wood Shingle','27 - Houston','GALLEGOS ELEMENTARY SCHOOL (HOUSTON)','MILBY HIGH SCHOOL','EDISON MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Other Style','Magnolia Park Sec 02','2428','2.3307','Public Sewer,Public Water','1940','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','215374280','1675087977','215374280','2022-12-06T12:07:53.427','91775027','Luke Volz','Realty ONE Group, Experience','','','30.474726','-95.572240','49','77318','4','1050000.00','Active','Calvary','14264','Road','Willis','1','1','3','1457','Single-Family','WOW! Talk about a rare opportunity. This cozy 3/4 bedroom, 1.5 bathroom, lakefront, Lake Conroe home sits on acreage boasting almost 2 acres (1.879). This home features a private boat slip and lift with 90ft of bulkhead, detached 3 car garage with extra storage, private well, outdoor pavilion with utility access, RV (included in sale), 2 RV slips with independent utility access, and is fully fenced (ready for horses etc). This open floor plan home has it all with a vaulted ceiling in the main room and large loft. Some of the homes features include tile flooring in main living areas, a spacious sunroom, rustic wood accents and beams throughout, a large kitchen with stainless steel appliances and dining room, spacious bedrooms (sleeps 15 currently) and much more! The massive covered outdoor pavilion is perfect for many uses such as a summertime bbq and can host large gatherings. This exclusive property next to Lake Conroe will not last long. Please call us for more information.','1.8795','39','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Lake Conroe Area','Central Electric','0','S672000 - LAKE RENEE, LOT 3, 4, 8-B, 8-C','Cleared,Corner,Water View,Waterfront','81870','Appraisal District','','','0','','3','Electric Oven','0','','','Electric Range','','Composition','56 - Willis','PARMLEY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','LYNN LUCAS MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Lake Renee','14085','1.8448','Aerobic,Septic Tank,Well','1976','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','215374725','1675087978','215374725','2022-12-06T12:15:31.460','92759646','Bradley Tiffan','Legend Home Corporation','','','29.831097','-95.804569','36','77493','6','279990.00','Active','Landolfi','24862','Drive','Katy','2','1','3','1849','Single-Family','Love where you live in Camillo Lakes in Katy, TX! The Chestnut plan is a charming 2-story home with 3 bedrooms, 2.5 bathrooms, and 2-car garage! This home has it all, including blinds, upgraded carpet in the bedrooms, and NO BACK NEIGHBORS! The first floor offers the perfect entertainment space with vinyl plank flooring and a large kitchen island overlooking the family and dining rooms! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless steel appliances! The second floor offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring double sinks, a sizable shower, and spacious walk-in closet! Secondary bedrooms have walk-in closets, too! Enjoy the great outdoors with full sod, sprinkler system, and covered patio! Don\'t miss your opportunity to call Camillo Lakes home, schedule a visit today!','','25','LEGEND HOMES','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Katy - Old Towne','Central Gas','1','LT 72 BLK 1 CAMILLO LAKES SEC 6','Cul-De-Sac,Subdivision Lot','2645','Survey','','875','1','Never Lived In','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','30 - Katy','LEONARD ELEMENTARY SCHOOL (KATY)','PAETOW HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','2','Traditional','Camillo Lakes','','3.53','Water District','2022','Builder'); --> New record created successfully