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-11-20T08:56:17.353' ,`MLSNumber` = '98594054' ,`ListAgentFullName` = 'Jeanette Bufkin' ,`ListOfficeName` = 'Vista Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.406448' ,`Longitude` = '-95.083143' ,`PhotoCount` = '48' ,`PostalCode` = '77510' ,`RoomCount` = '7' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'AVE J' ,`StreetNumber` = '2500' ,`StreetSuffix` = '' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2335' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING HOME ON aprox.6 ACRES. WITH 50X40 RV SPACE, SHOP, AND STORAGE.PLUS SOME COVERED PARKING. THIS LOVELY HOME HAS 4 BEDROOMS.THE LARGE LIVING ROOM AND 4TH BEDROOM HAS A DOOR TO THE OUTSIDE PATIOS. MASTER BEDROOM WITH TWO CLOSETS PLUS LINEN CABINET. THE LAUNDRY AND PANTRY ROOM IS A GREAT SIZE WITH LOTS OF CABINETS. LARGE OPENING BETWEEN KITCHEN, DINING, AND LIVING ROOM IS GREAT FOR ENTERTAINING. THIS PEACEFUL SITTING HAS A ORANGE ,1 PEARS ,AND OAKS TREES.ROOM TO RELAX AWAY FROM THE WORLD BUT STILL CLOSE THE STORES AND SHOPPING. NO SURVEY OLD DEED SHOWS A LITTLE OVER 6ACRES WHICH INCLUDEDS THE ROAD ( FROMTHE CAD S PLAT MAP )' ,`Acres` = '6' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'PT OF LOT 170 (170-5) THAMANS 3RD SUB' ,`LotDesciption` = 'Cleared' ,`LotSize` = '260488' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = '' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'THAMAN 3RD' ,`TaxAmount` = '11157' ,`TaxRate` = '2.35362' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054876' WHERE `Matrix_Unique_ID` = '208453652' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T08:00:54.760' ,`MLSNumber` = '31485758' ,`ListAgentFullName` = 'Nehal Farrag' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = 'Lan Le' ,`SellingOfficeName` = 'MaiAn Realty' ,`Latitude` = '29.829795' ,`Longitude` = '-95.799234' ,`PhotoCount` = '21' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '365000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Carlo Hue' ,`StreetNumber` = '24519' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2129' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy your own slice of paradise in this gorgeous home in Camillo Lakes built right on the lake! This home which was built in 2021 features 4 bedrooms and 2 1/2 baths. Open floor concept with amazing views of the lake from the kitchen and living room. The kitchen has plenty of storage, a large island and beautiful granite countertops. The primary bedroom which is on the first floor also has lake views and an ensuite bathroom with double sinks, shower and tub. Upstairs you will find 3 spacious bedrooms and a large game room. Enjoy your days and evenings under the covered patio and perfect views of the fully stocked lake and fountain. Refrigerator, washer and dryer are included. Contact me or your agent to check this house out today! Seller is motivated!' ,`Acres` = '0.096' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 4 CAMILLO LAKES SEC 4' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '4181' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes Sec 4' ,`TaxAmount` = '9030' ,`TaxRate` = '3.5333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669054876' WHERE `Matrix_Unique_ID` = '208949837' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T07:01:26.487' ,`MLSNumber` = '24506489' ,`ListAgentFullName` = 'Stephanie Nelson' ,`ListOfficeName` = 'Prime Properties' ,`SellingAgentFullName` = 'Brian Covault' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.566538' ,`Longitude` = '-95.713761' ,`PhotoCount` = '30' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '347000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Coleridge' ,`StreetNumber` = '2306' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2418' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TONS of FABULOUS UPDATES and FEATURES include: tile (wood look) flooring 2016, kitchen cabinet doors 2016, baseboards 2016, door frames 2016, backsplash 2016, lighting 2016, primary closet build-out, gutters, landscaping, dishwasher 2021, induction cooktop 2016, interior paint 2016, motion detectors, lights on timers, water line in garage for a refrigerator, kitchen refrigerator stays, water heater 2019, water softener 2021, Rachio smart control for sprinkler system, exterior paint 2019, sliding pantry door to walk-in pantry, covered back patio w/ceiling fans, spacious kitchen with lots of counter space. OPEN FLOOR PLAN, breakfast bar, CONVENIENT LOCATION close to Hwy 59, Hwy 99, FM 762, Hwy 90. Easy access to medical facilities, restaurants, and retail. Don\'t miss this one. It\'s a move-in-ready show stopper!' ,`Acres` = '0.1682' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERPARK WEST SEC 5, BLOCK 2, LOT 17' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7326' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`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,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Riverpark West' ,`TaxAmount` = '6732' ,`TaxRate` = '2.8748' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054876' WHERE `Matrix_Unique_ID` = '209390935' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T08:57:44.150' ,`MLSNumber` = '49477665' ,`ListAgentFullName` = 'Kelly Kelley' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = 'Jessica Dempsey' ,`SellingOfficeName` = 'Greater Houston REP, Inc.' ,`Latitude` = '29.145273' ,`Longitude` = '-95.036515' ,`PhotoCount` = '47' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '1049000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Scissor Tail' ,`StreetNumber` = '21222' ,`StreetSuffix` = 'Lane' ,`City` = 'Galveston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Coastal meets modern in this premier new construction home with Gulf AND Bay views. There is so much to love about this home from the floorplan to the finishes to the Summer sunset bay views. Inverted floorplan maximizes the views from the living areas. 3 bedrooms with en-suite baths, the utility room, & 2nd living area occupy the main level of the home. Primary retreat, & open concept living space are on 2nd level. Finishes in this home include Carrera Marble tile, shiplap walls, 10ft ceilings on both living floors, 250 Gallon buried Propane Tank, 15 ft vaulted ceiling (kitchen/living/dining), A/V pre-wired (family, living, upstairs porch, TV all bedrooms), Twin 55 Gallon – Wifi Electric Rheem water heaters, Isokern vent free fireplace, & outdoor stainless fireplace. Enclosed garage allows plenty of room for storage. Sunset Cove is a gated community with a pool, tennis court, boat ramp & golf cart ride to beach access. AT&T Fiber access. Furniture is for staging purposes only.' ,`Acres` = '0.3444' ,`Area` = '33' ,`BuilderName` = 'owner' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'ESTATES OF SUNSET COVE PH 2 (2016) ABST 121, BLOCK 3, LOT 6,' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '15000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Sunset Cove' ,`TaxAmount` = '' ,`TaxRate` = '2.2124' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054877' WHERE `Matrix_Unique_ID` = '209698243' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T07:03:01.083' ,`MLSNumber` = '43299009' ,`ListAgentFullName` = 'Chandal Franger' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = 'Becky Dale' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.887840' ,`Longitude` = '-94.403321' ,`PhotoCount` = '48' ,`PostalCode` = '77665' ,`RoomCount` = '10' ,`ListPrice` = '399900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Fm 1406' ,`StreetNumber` = '14905' ,`StreetSuffix` = 'Road' ,`City` = 'Winnie' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2390' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living at its best! This beautiful ranch-style home is located on 5.1 well-maintained acres that is fully fenced and surrounded by mature trees. This home features a wood-burning fireplace, a beautiful enclosed sunroom and covered livestock stalls with a tack room! Fenced and cross fenced.Never flooded per seller.' ,`Acres` = '5.1' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 26-A 642 H LEFLORE 1.000' ,`LotDesciption` = 'Cleared' ,`LotSize` = '225161' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'CHINA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'NA' ,`TaxAmount` = '3797' ,`TaxRate` = '1.8511' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669054877' WHERE `Matrix_Unique_ID` = '211204476' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T07:39:05.520' ,`MLSNumber` = '39323072' ,`ListAgentFullName` = 'Laura Austin' ,`ListOfficeName` = 'REALTY TEXAS LCA, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.296889' ,`Longitude` = '-95.487514' ,`PhotoCount` = '50' ,`PostalCode` = '77304' ,`RoomCount` = '9' ,`ListPrice` = '574990.00' ,`Status` = 'Active' ,`StreetName` = 'Pebblestone' ,`StreetNumber` = '6' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3026' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in a Cul-De-Sac street on a serene 1 Acre lot in a gated community. Here is the 3026 sq ft 1 story home you have been looking for, the space without the stairs! Yippee! Husbands, you know how sometimes you are not able to always get what YOU want in a home... Well, you will be in Garage Heaven when you see all the storage, fans, workbench, insulation, etc.,& it can all be yours! Now, Ladies, you will not be left out in the storage department, WOW, all the cabinets in the Kitchen and Walk-In Closets are everywhere! You can store to your heart\'s desire. Are you working from Home? You will have your own office with a wall of built-ins and a view of your spacious backyard. This open spacious home with a covered slate patio will be great for entertaining at your upcoming House Warming Party with your friends & family. Kitchen Frig & Micro to Stay. You will have easy access to I-45, 336 Marketplace, Lake Conroe, The Woodlands,etc. Call today to schedule your viewing before it\'s gone.' ,`Acres` = '1' ,`Area` = '19' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SILVERSTONE 01, BLOCK 2, LOT 60' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RICE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Silverstone 01' ,`TaxAmount` = '9226' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054877' WHERE `Matrix_Unique_ID` = '211414140' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T08:54:09.420' ,`MLSNumber` = '49510673' ,`ListAgentFullName` = 'Melissa Cruz' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.145300' ,`Longitude` = '-95.027314' ,`PhotoCount` = '23' ,`PostalCode` = '77327' ,`RoomCount` = '8' ,`ListPrice` = '119000.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5265' ,`StreetNumber` = '93' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom 2 bath home on an over 1/3 acre lot in growing Cleveland, TX. Large living room and kitchen with eat-in breakfast area. Primary bedroom features large walk-in closet and en-suite bath with dual-sink vanity, large soaking tub, and separate shower. Enjoy gardening and family fun in your spacious yard or afternoon BBQ on the patio. Easy commute on Grand Pkwy 99 and Hwy 59 and only 45 minutes to Downtown Houston.' ,`Acres` = '0.39' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 2, BLOCK 35, LOT 4140, ACRES 0.39' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '16988' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '1070' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054877' WHERE `Matrix_Unique_ID` = '211747564' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T08:58:03.227' ,`MLSNumber` = '84771216' ,`ListAgentFullName` = 'Elizabeth Flores-Sauceda' ,`ListOfficeName` = 'Century Properties Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029363' ,`Longitude` = '-95.313947' ,`PhotoCount` = '27' ,`PostalCode` = '77338' ,`RoomCount` = '7' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Fox Walk' ,`StreetNumber` = '21246' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1754' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great one story home nestled in the Foxwood Subdivision. This home features a beautiful large living room that is opened to the kitchen. Great for entertaining. There\'s a formal dining and a breakfast room, lots of room for the holiday gatherings. Seller has wired the house with surround sound, under the counter lighting, a switch indoors to turn Christmas lights on and off without stepping out and the pantry lights up upon opening the door and off when closing. You will be surprised with all the electrical extras in the house being the seller is an electrician. \r\nThe master bedroom is separated from the secondary rooms. Call today for a private showing.' ,`Acres` = '0.1178' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 FOXWOOD SEC 13' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5131' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '310' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Foxwood Sec Thirteen' ,`TaxAmount` = '4965' ,`TaxRate` = '2.7734' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054878' WHERE `Matrix_Unique_ID` = '212699000' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T07:40:31.957' ,`MLSNumber` = '46713036' ,`ListAgentFullName` = 'Marissa Stevens' ,`ListOfficeName` = 'RE/ImageProperties and Investm' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.948682' ,`Longitude` = '-95.565966' ,`PhotoCount` = '19' ,`PostalCode` = '77070' ,`RoomCount` = '4' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Pass' ,`StreetNumber` = '9807' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2150' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 bedrooms house. Located close to 1960, Perry and 249 near to Willowbook mall. Tile on the 1st floor, carpet on the second floor. Detached garage.' ,`Acres` = '0.202' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 WOODEDGE VILLAGE SEC 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'DANISH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodedge Village' ,`TaxAmount` = '6177' ,`TaxRate` = '2.8087' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054878' WHERE `Matrix_Unique_ID` = '212852170' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T08:02:48.463' ,`MLSNumber` = '59468550' ,`ListAgentFullName` = 'Michael Green' ,`ListOfficeName` = 'Reward Realty' ,`SellingAgentFullName` = 'Johnna Johnson' ,`SellingOfficeName` = 'RE/MAX Fine Properties' ,`Latitude` = '29.462928' ,`Longitude` = '-95.077758' ,`PhotoCount` = '50' ,`PostalCode` = '77539' ,`RoomCount` = '15' ,`ListPrice` = '579900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Shady Oak' ,`StreetNumber` = '1024' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '7' ,`SqFtTotal` = '5007' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updates to HOME***fresh paint both in and out***new wood floors***new carpet***kitchen redone with quartz tops and tile backsplash***new appliances***fireplace redone with glass tile***both bathrooms completely redone***all new lights and fans***enclosed patio with new laminate floors***fresh landscapin***Updates to GARAGE APARTMENT***fresh paint inside***kitchen redone with granite tops and new appliances***new lights and fans***new carpet***new laminate floors***bathrooms updated***SHOW THIS HOME ITS WILL SELL SELF.' ,`Acres` = '0.455' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 19 PERRY & AUSTIN SUR LOT 30 OAK HOLLOW SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'BAY COLONY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Hollow 2' ,`TaxAmount` = '9512' ,`TaxRate` = '2.5214' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054878' WHERE `Matrix_Unique_ID` = '213050775' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T07:30:17.130' ,`MLSNumber` = '15168170' ,`ListAgentFullName` = 'Danielle Dove' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.372475' ,`Longitude` = '-95.537901' ,`PhotoCount` = '37' ,`PostalCode` = '77304' ,`RoomCount` = '9' ,`ListPrice` = '384500.00' ,`Status` = 'Active' ,`StreetName` = 'Masquerade' ,`StreetNumber` = '7318' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2815' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impressive 4 bedroom, 2 1/2 bath has been well maintained by original owners. Inside is immaculate, spacious, freshly painted and ready for you to call Water Crest your new home! There is a formal dining, massive living room, 1/2 bath and Primary Suite downstairs. Upstairs has a drop zone for an office or game room. Three generous sized bedrooms share a common bathroom plus storage and closets. Security systems are in place with cameras throughout the home and smart light switches allow you to control them from anywhere on your phone. Walk-in pantry, a generator is included for emergency situations, French drains are installed for exceptional drainage, a whole home water softener system provides high quality water. Does your pet need its privacy? A custom dog room was built in under the stairs! Washer, dryer, refrigerator included. Amenities are a lap pool and secondary pool overlooking Lake Conroe, boat ramp, clubhouse, walking trails, playground. Highly rated schools. Come see today!' ,`Acres` = '0.1641' ,`Area` = '39' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S954408 - WATER CREST ON LAKE CONROE 08, BLOCK 1, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`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` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Water Crest On Lake Conroe 08' ,`TaxAmount` = '7880' ,`TaxRate` = '3.0823' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054878' WHERE `Matrix_Unique_ID` = '213584121' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T08:54:27.237' ,`MLSNumber` = '27321958' ,`ListAgentFullName` = 'Lee DeForke Jr.' ,`ListOfficeName` = 'Lee DeForke Jr.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.208141' ,`Longitude` = '-94.933345' ,`PhotoCount` = '35' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Pirates Beach' ,`StreetNumber` = '13546' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Now its your turn to enjoy the Island life and only a 2 minute walk to your beach. This home sits a few rows back from the Gulf of Mexico and will give you the benefits of island life without big costs. Come see this 3 bedroom, 2 bath home, ready for you and your family to enjoy for the rest of the year and then be ready for the summer of 2023. Make this a vacation rental and sit back and enjoy the income and still get to use it when you want. Easy access to island activities and golf. Come see.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 45 LOT 20 BLK 10 PIRATES BEACH SEC 3' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '332' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`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` = 'Traditional' ,`Subdivision` = 'Pirates Beach 3' ,`TaxAmount` = '4176' ,`TaxRate` = '2.40325' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054878' WHERE `Matrix_Unique_ID` = '213584135' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T08:47:27.250' ,`MLSNumber` = '55315650' ,`ListAgentFullName` = 'Shawn Baksh' ,`ListOfficeName` = 'Trotwood Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.709214' ,`Longitude` = '-95.649207' ,`PhotoCount` = '47' ,`PostalCode` = '77083' ,`RoomCount` = '9' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Modesto' ,`StreetNumber` = '6307' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home has 4 bed with 2.5 bath, a 2 car garage home and many amazing features. Hugh 2 story high ceiling living room with a bricked fireplace surround. A dining room wood like floors & direct access to the kitchen, making it perfect for all your entertaining needs! A Chefs kitchen equipped with granite counters, tile floors & tons of amazing wood cabinets! Primary suite with its own bath with twin vanities and a walk-in closet. Upstairs is a game changer with a huge game room & all 3 secondary bedrooms up! Roof replaced in June 2022, siding replaced in July 2022. Backyard with plenty of green space & an open patio! Call today.' ,`Acres` = '0.1901' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 7 ALTAMIRA SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'PETROSKY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Altamira Sec 01' ,`TaxAmount` = '4850' ,`TaxRate` = '2.5785' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054879' WHERE `Matrix_Unique_ID` = '213808557' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T08:44:56.807' ,`MLSNumber` = '3834613' ,`ListAgentFullName` = 'Jamie Johnston' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.111550' ,`Longitude` = '-95.512697' ,`PhotoCount` = '26' ,`PostalCode` = '77389' ,`RoomCount` = '6' ,`ListPrice` = '398000.00' ,`Status` = 'Active' ,`StreetName` = 'Creekview' ,`StreetNumber` = '24006' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2111' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated one story home in Northampton. New granite countertops in kitchen and primary shower. Fresh paint and new flooring in kitchen, living, breakfast, and hallway. New kitchen appliances just installed. Drive your golf cart to the Willow Creek Golf Club or enjoy the privacy of a lot with no backyard neighbors. This home also features an air-conditioned bonus room attached to the garage (not included in square footage). This room is perfect for a home office or exercise room. Northampton is close to ExxonMobil, The Woodlands, and 99.' ,`Acres` = '0.343' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 24 017*N5959000-003-024-005 NORTHAMPTON SEC 3' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '14940' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NORTHAMPTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northampton Sec 03' ,`TaxAmount` = '6248' ,`TaxRate` = '2.664' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054879' WHERE `Matrix_Unique_ID` = '213847324' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T08:37:13.873' ,`MLSNumber` = '73580017' ,`ListAgentFullName` = 'Lucia Clark' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.049423' ,`Longitude` = '-95.381504' ,`PhotoCount` = '17' ,`PostalCode` = '77373' ,`RoomCount` = '5' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Prairie Bird' ,`StreetNumber` = '23206' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '892' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 23206 Prairie Bird Drive. This quaint 2-bedroom 1 bathroom home is located in Cypress Trails Timberlane. The home boasts Wood Look Tile throughout the living area and kitchen and the bedrooms have recently replaced carpet (Oct 2022). The neutral paint pallet and flooring updates make this home move in ready. The home is conveniently located near the Hardy Toll Road and I45 for an easy commute across town. Take a trip to Old Town Spring just a few minutes away for a unique shopping and dining experience. The home has a large backyard perfect for pets, a playset, or entertaining. The backyard paver patio is a great spot for a BBQ or morning coffee. Don\'t miss the opportunity to secure this fantastic home. Take a look today.' ,`Acres` = '0.1263' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 16B & 17B BLK 6 CYPRESS TRAILS OF TIMBERLANE 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Trails Timberlane' ,`TaxAmount` = '2554' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054879' WHERE `Matrix_Unique_ID` = '213849150' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T08:44:55.527' ,`MLSNumber` = '14156384' ,`ListAgentFullName` = 'Tiffani Reynolds' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = 'Sandra Marconi' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '30.185382' ,`Longitude` = '-95.799893' ,`PhotoCount` = '29' ,`PostalCode` = '77355' ,`RoomCount` = '9' ,`ListPrice` = '240000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Angelico' ,`StreetNumber` = '22048' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this home built in 2020 in the Williams Trace subdivision. This beautiful home has vinyl flooring throughout the entire space and NO CARPET. The kitchen has an expansive amount of granite countertops with lots of cabinetry, and stainless steel appliances. The kitchen is great for meal prep and hosting large gatherings. It connects to the living room and creates that open floor plan you’ve been looking for. The primary bedroom is just off the living room, complete with a large walk-in closet and private en-suite with a separate tub and shower. The two secondary bedrooms are situated away from the primary bedroom, allowing more peace and quiet in the owner’s retreat. The refrigerator will stay with the home! Outside you will find a large covered patio, perfect for relaxing, and a large yard that is ready to be enjoyed. Schedule your showing today.' ,`Acres` = '0.1124' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S955202 - WILLIAMS TRACE 02, BLOCK 7, LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4897' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '348' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Williams Trace' ,`TaxAmount` = '3784' ,`TaxRate` = '1.9722' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669054879' WHERE `Matrix_Unique_ID` = '213872246' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T07:03:06.637' ,`MLSNumber` = '23817910' ,`ListAgentFullName` = 'April Lorenz' ,`ListOfficeName` = 'Zuri Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.668399' ,`Longitude` = '-95.321649' ,`PhotoCount` = '27' ,`PostalCode` = '77033' ,`RoomCount` = '4' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridgeway' ,`StreetNumber` = '6143' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1873' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this lovely one story home with so much to offer. Large living areas and open floor plan. Tile throughout home. Bedrooms are large with huge closets that offer lighting. Upgraded bathrooms. Large backyard with plenty of room. Close to UofH, Hobby Airport, Medical Center, and Reliant Stadium.' ,`Acres` = '0.1501' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 42 EDGEWOOD SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6540' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALCOTT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Edgewood Sec 09' ,`TaxAmount` = '3944' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054880' WHERE `Matrix_Unique_ID` = '214001355' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T07:07:10.240' ,`MLSNumber` = '76797338' ,`ListAgentFullName` = 'Cathy Barnes' ,`ListOfficeName` = 'Prime Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.917966' ,`Longitude` = '-95.507855' ,`PhotoCount` = '19' ,`PostalCode` = '77086' ,`RoomCount` = '3' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Wood' ,`StreetNumber` = '9402' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1313' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make this house a “home” - Ready for move in. Lots of recent updates have been completed. Brand new “craftsman style” front door. The kitchen has granite installed with ‘Santorini’ brick marble backsplash and crisp, clean white cabinets. All appliances have been updated to stainless steel. Laminate flooring through-out the main living area and Primary suite. The fireplace is a show stopper and has been designed with shiplap planks and tile. All bathrooms have brand new vanities, brand new toilets, new fixtures, flooring and tile in the showers. Modern light fixtures installed along with LED lights. Brand new 40 gallon hot water heater. All windows in the front of the house have been replaced to double pane. Brand new Electrical Panel Box. Oversized garage space. Large backyard with a patio and huge, mature tree that gives lots of shade. A/C and Roof 4-5 years old. The Neighborhood has a park and pool.' ,`Acres` = '0.1612' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 17 017*W3466200-003-017-013 WILLOWOOD SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '345' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EPPS ISLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willowood Sec 03' ,`TaxAmount` = '3125' ,`TaxRate` = '2.8555' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054880' WHERE `Matrix_Unique_ID` = '214077569' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T08:17:25.703' ,`MLSNumber` = '31109057' ,`ListAgentFullName` = 'Austin Davis' ,`ListOfficeName` = 'Rogers Healy & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.565142' ,`Longitude` = '-95.419227' ,`PhotoCount` = '45' ,`PostalCode` = '77584' ,`RoomCount` = '5' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Quail Creek' ,`StreetNumber` = '12811' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2867' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move in ready 2-story home built in 2006 nestled in the highly sought after Shadow Creek Ranch Community. This is one of the few 5 bed /3.5 bath homes at this price point! Beautiful exterior, high ceilings, cozy gas fireplace. Open concept floorplan joins main living to the spacious kitchen with granite counters, island, butlers pantry perfect for coffee bar. First-floor primary suite with dual vanities, jetted tub, and two spacious closets. Second floor is complete with 4 spacious bedrooms. One of which is a Mother-In-Law Suite with its own full bath. Come relax in your amazing backyard w/ covered patio and luscious grass. Close to community walking trails, pools, parks & splash pad. See this one first and make it your next home! Easy access to 288 tollway or Beltway, 20 minutes to Texas Medical Center and 22 Minutes to Downtown, nearby Pearland Town Center Mall, shopping, dining, and more!' ,`Acres` = '0.1635' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-38A (PEARLAND), BLOCK 4, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7122' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'YORK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MCNAIR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf1-Sf2-Sf3' ,`TaxAmount` = '11119' ,`TaxRate` = '3.5409' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054880' WHERE `Matrix_Unique_ID` = '214162027' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T08:15:01.500' ,`MLSNumber` = '81155295' ,`ListAgentFullName` = 'Kay Krampitz' ,`ListOfficeName` = 'Texas Trust Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847305' ,`Longitude` = '-96.164284' ,`PhotoCount` = '16' ,`PostalCode` = '77474' ,`RoomCount` = '9' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 331' ,`StreetNumber` = '734' ,`StreetSuffix` = 'Road' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '3216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Historical Farmhouse with tons of character! This amazing home was built in the early 1900\'s and relocated to Sealy. There is so much history here and road frontage on both sides of the property. This home sits on 1.2 acres with lots of mature trees. There is a fabulous welcoming front porch with a beautiful wood front door. When you enter the home, you will immediately notice the high ceilings, and an abundance of farmhouse charm. This home just goes on and on with over 3000 Sq. Ft. The backyard has a fantastic, heated saltwater pool and it has a cover. There is a spacious kitchen with an island and tons of storage cabinets. Many updates including a top-of-the-line TRANE A/C unit, and recent Paint inside and out. There is a 2 car garage with lots of storage. This could be your own gem in the Country. Seller is very motivated!' ,`Acres` = '1.198' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'CRICK SUB. (OUT OF ABST 31)LOT 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '52185' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Fiberglass,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Crick Sub' ,`TaxAmount` = '4690' ,`TaxRate` = '1.8832' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054880' WHERE `Matrix_Unique_ID` = '214207851' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T07:22:09.223' ,`MLSNumber` = '78475376' ,`ListAgentFullName` = 'Billy Martinez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.785881' ,`Longitude` = '-95.167266' ,`PhotoCount` = '38' ,`PostalCode` = '77015' ,`RoomCount` = '4' ,`ListPrice` = '228800.00' ,`Status` = 'Active' ,`StreetName` = 'Longview' ,`StreetNumber` = '14416' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1788' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move in ready gated home, no restrictions , mix use area with lots of new construction. The home is equipped with granite countertops throughout, 30 inch range, custom cabinetry. Beautiful engineered floors and tile and recessed lighting. MOVE IN READY! Schedule a showing!' ,`Acres` = '0.1288' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 88 CLOVER LEAF' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '5610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'SAM HOUSTON ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clover Leaf' ,`TaxAmount` = '1757' ,`TaxRate` = '2.5853' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054881' WHERE `Matrix_Unique_ID` = '214375444' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T07:44:23.690' ,`MLSNumber` = '83119594' ,`ListAgentFullName` = 'Richard Fenyes' ,`ListOfficeName` = 'Rocket, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.618939' ,`Longitude` = '-95.408692' ,`PhotoCount` = '20' ,`PostalCode` = '77047' ,`RoomCount` = '6' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Belmont Legend' ,`StreetNumber` = '12931' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Clean spacious home ready for move in; NOT in a flood zone. Close to major thoroughfares of 288 & Beltway 8 . Home features ample living space with great family functionality including a large family room, dining area and a kitchen with really good counter space and a bar-top area. The downstairs upgraded guest powder/half-bath room is great for guests and just awesome to have. The GAME ROOM is perfect for lounging and can also be used as a flexible area. The well sized Primary bedroom includes an additional sitting area while the Primary Bath has a very nice XTRA wide soaking tub and the walk-in closet gives a good amount of space. All of the bedrooms are large and accommodating. The front driveway is elongated which is perfect for additional parking. Good to know the hot-water heater is located within the 2 car garage while the in-home laundry can fit full size washer and dryer. The community offers walking trails, a splash pad area for the kids and a park with playground. Nice home.' ,`Acres` = '0.1063' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 2 REGAL OAKS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4630' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '436' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALMEDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Regal Oaks Sec 03' ,`TaxAmount` = '5850' ,`TaxRate` = '2.9007' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054881' WHERE `Matrix_Unique_ID` = '214441232' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T07:47:58.493' ,`MLSNumber` = '58886512' ,`ListAgentFullName` = 'Krystal Velazquez' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.983097' ,`Longitude` = '-95.141212' ,`PhotoCount` = '47' ,`PostalCode` = '77044' ,`RoomCount` = '4' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = 'Octavio Frias' ,`StreetNumber` = '18207' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2438' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to the highly sought-after community of Bridges on Lake Houston. This charming home features a unique floorplan with desirable touches throughout offering 4 bedrooms, 3 FULL bathrooms, freshly painted, tankless water heater, keyless entry, high ceilings, a secondary bedroom with an en suite full bathroom, formal dining, open concept layout perfect for entertaining. Primary suite with huge walk-in closet privately tucked away. The gorgeous kitchen boasts an expansive island, granite countertops, 42” cabinets with an abundance of storage space, stainless steel appliances, under mount cabinet lighting, a grand walk-in pantry, subway tile backsplash, and a butler’s pantry. Refrigerator included. On the exterior, you will find all 4 sides bricked, sprinkler system, and an extended patio with a custom firepit to enjoy. Residents enjoy lakefront amenities with breathtaking views! Schedule your tour today. Room sizes are approximate.' ,`Acres` = '0.1989' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 47 BLK 2 BRIDGES ON LAKE HOUSTON SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8665' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKESHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridges/Lk Houston Sec 7' ,`TaxAmount` = '9025' ,`TaxRate` = '3.303' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054881' WHERE `Matrix_Unique_ID` = '214508104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T07:50:09.250' ,`MLSNumber` = '56722126' ,`ListAgentFullName` = 'Eric Robinson' ,`ListOfficeName` = 'RE/MAX Preferred Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.352845' ,`Longitude` = '-95.608741' ,`PhotoCount` = '10' ,`PostalCode` = '77316' ,`RoomCount` = '3' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Powder River' ,`StreetNumber` = '400' ,`StreetSuffix` = 'Circle' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this lovely 3 bed 2 full bath home, located on a cul-de-sac in Lake Conroe Forest. Primary bedroom and 2 secondary bedrooms are located downstairs. Full bathrooms on both floors. Stainless steel gas range in fully updated kitchen! The neighborhood features access to a private boat ramp to Lake Conroe. Neighborhood is close to lakeside restaurants, shopping, events, and activities in Lake Conroe. House sits on 2 lots at 15,639 total lot sqft. Home is fully updated, exterior and interior, to a modern taste with open space to make this home fit your needs.' ,`Acres` = '0.1598' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CONROE FOREST 02, BLOCK 31, LOT 32' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '15639' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe Forest 02' ,`TaxAmount` = '1684' ,`TaxRate` = '2.1625' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054881' WHERE `Matrix_Unique_ID` = '214605748' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T07:43:42.880' ,`MLSNumber` = '54208002' ,`ListAgentFullName` = 'Dao Vo' ,`ListOfficeName` = 'Intercontinental Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.968069' ,`Longitude` = '-95.393783' ,`PhotoCount` = '15' ,`PostalCode` = '77073' ,`RoomCount` = '9' ,`ListPrice` = '288000.00' ,`Status` = 'Active' ,`StreetName` = 'Ranch View' ,`StreetNumber` = '18439' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Big House, Big extra lot free use. Inside many rooms. Down stair tile, Up stair carpet. House with Refrigerator , washer/dryer.....Sell fast' ,`Acres` = '0.1085' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 REMINGTON CREEK RANCH SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '410' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Left Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Remington Crk Ranch Sec 1' ,`TaxAmount` = '5813' ,`TaxRate` = '2.8445' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669054882' WHERE `Matrix_Unique_ID` = '214683004' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T07:42:12.997' ,`MLSNumber` = '18963864' ,`ListAgentFullName` = 'Jackie Spiro' ,`ListOfficeName` = 'NextHome Realty Center' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.932782' ,`Longitude` = '-95.674792' ,`PhotoCount` = '50' ,`PostalCode` = '77095' ,`RoomCount` = '7' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Lonesome Dove' ,`StreetNumber` = '10715' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Quiet Cul-de-Sac & Corner location! Move in Ready. High Ceilings welcome you Home! Freshly Painted inside. Lots of Architectural Features, Arches & Niches, Crown Molding. No Carpet, Wood floors in the Bedrooms & Tile Floors in all the other areas for easy maintenance and cleaning. Spacious Kitchen with lots of Tall Cabinets & Counter space, Stainless Steel Appliances recently replaced, Walk-in Pantry. Kitchen is open to Living & Breakfast Room. Cozy Fireplace in Living Room. Generous Size Primary Bedrooms is privately located on the back of the home, Double Vanity, Separate Shower & Jetted Tub, Lg Walk-in Closet. Ring Door Bell is Included. Full Gutters & Sprinkler System. Riata Ranch offers a Splash Pad, Pool, Park & Playground. Minutes from Towne Lake Boardwalk, Shopping, Dining & Houston National Golf Course. Easy Access to Hwy 290. Zoned to Top Rated Schools. No Flooding per Sellers. Roof Replaced in 2014. Water Heater & A/C replaced in 2019. Low Tax Rate. Large Corner Lot!' ,`Acres` = '0.171' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric 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 8 BLK 3 RIATA RANCH SEC 5' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '7449' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '844' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WOODARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riata Ranch' ,`TaxAmount` = '6059' ,`TaxRate` = '2.711' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054882' WHERE `Matrix_Unique_ID` = '214726462' --> 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','214744687','1669054882','214744687','2022-11-20T08:15:26.820','85922699','Gayla Gayden','REALM Real Estate Professional','','','29.698273','-95.456104','34','77401','11','690000.00','Active','Evergreen','4605','Street','Bellaire','2','0','3','1520','Single-Family','Inside the Loop in Bellaire surrounded by Million Dollar Homes! 1 Story Ranch Home Completely Remodeled down to the Studs! Huge Lot almost 9,000 Sq Ft! Updated Energy Features W/Insulated Vinyl Double Hung Windows, Exterior Doors, Water Heater, Plumbing PEX, Electrical & More! Covered Porch Elevation! Grand Entry W/Stunning Wood Floors! Casual Dining flows into Gourmet Kitchen & Family Area! Gourmet Kitchen W/Soft Closing Tall White Shaker Cabinets & Drawers, Pots & Pan Drawers, Lazy Susan Corner Cabinets, Copper Farmhouse Sink, Stainless Steel Appliances W/5 Burner Gas Range, Copper Vent Hood, Natural Quartzite Stone Counters, Sleek Backsplash, Pendant Lights & More! Fabulous Guest Bathrm W/European Large Sink Vanity, Cassis Arte Tile Floors, Freestanding Soaker Tub & Shower! Private Owner\'s Retreat W/Wood Floors, Frosted Glass Barn Door, Luxurious Custom European Style Bathrm W/Double Sink Vanity, Shower W/Bench & More! Covered Patio, Storage Shed & more! NEVER FLOODED! Top Schools','0.2045','17','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Bellaire Area','Central Gas','0','LT 3 EVERGREEN','Subdivision Lot','8910','Appraisal District','','','0','','1','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','HORN ELEMENTARY SCHOOL (HOUSTON)','BELLAIRE HIGH SCHOOL','PERSHING MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern,Traditional','Evergreen','10560','2.2271','Public Sewer,Public Water','1955','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T08:56:41.487' ,`MLSNumber` = '81706064' ,`ListAgentFullName` = 'Jennifer Mestayer' ,`ListOfficeName` = 'Cy-Fair Real Estate' ,`SellingAgentFullName` = 'Christopher Cooley' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.940332' ,`Longitude` = '-95.726141' ,`PhotoCount` = '25' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '465000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Seminole Ridge' ,`StreetNumber` = '16650' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open House cancelled. Charm and comfort best describe this sweet home built by J. Kyle Homes. From the moment you walk through the picket fence up the front steps to the large front porch you will notice that every detail is picture perfect! The home boast of 3 bedrooms, 3 bathrooms and a 3-car tandem garage. Both the interior and exterior of the home have been painted including the baseboards & kitchen cabinets! The kitchen has one year old appliances with double ovens, gas cooktop & large walk in pantry. You will love the light fixtures, plantation shutters, tall ceilings & new hardware found throughout this home. The primary bedroom and ensuite bathroom are both spacious, but the primary closet is the BEST one you have ever seen. The carpet and AC were replaced, and a sprinkler system and gutters were added in 2021. There is a huge covered patio in the back of the home and a complete set of gutters.' ,`Acres` = '0.1435' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 5 LAKELAND HEIGHTS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'BRIDGELAND' ,`TaxAmount` = '12135' ,`TaxRate` = '3.4329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054882' WHERE `Matrix_Unique_ID` = '214819761' --> 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','214899770','1669054882','214899770','2022-11-20T07:44:04.703','46106130','Amanda Hofstra','Keller Williams Advtge Realty','','','30.347261','-95.599990','42','77316','5','300000.00','Active','Youpon','1125','Drive','Montgomery','1','0','3','1144','Single-Family','Welcome to 1125 Youpon Dr in Lake Conroe Forest. This newly updated 3 bedroom + 1 bath home is on 1.62 acres nestled in a quiet cul de sac & ready to make your own. The front entry leads you straight into a large living/dining flex space & is open to the kitchen w/ refrigerator included! The primary bedroom has an added 8x8 flex space that could be used as an office or nursery. The back door opens to a large back porch w/ lots of trees for privacy. The property is fully fenced & has a barn. The potential is endless, so make your appointment today!','1.6247','39','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Lake Conroe Area','Central Electric','1','LAKE CONROE FOREST 02, BLOCK 8-C, LOT 4','Cul-De-Sac','70773','Appraisal District','','125','0','','0','Electric Oven','0','','','Electric Range','','Composition','37 - Montgomery','KEENAN ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Contemporary/Modern','Lake Conroe Forest 02','3327','2.1625','Public Water','1978','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','214931054','1669054882','214931054','2022-11-20T08:59:05.390','77875329','Tamika Shotwell','CB&A, Realtors','','','30.750907','-95.200603','49','77364','5','699000.00','Active','Pinemont','512','Drive','Point Blank','3','1','3','2081','Single-Family','Breath taking lake view property featuring two floors of open concept living. This well-designed home has covered porches on the first and second floor with great views of the lake. The second floor boasts a large open area with an updated kitchen with stainless steel appliances and an oversized island. A dinning and living room area that looks out on to the water from the wall of windows and sliding doors that bring in the lake breeze in the evening. There is a spacious master with lake views and a large walk-in shower and closet. The secondary bedroom has lake views too and its own private bath. The first floor is set up like a guest suite with a kitchen that has a breakfast bar and stainless-steel appliances. There is a living area and fabulous views from every angle. The first floor is currently an active short-term rental on Airbnb. There is also a 20X24 garage/shop. Extensive updates continuously completed on the property from 2018-2020. Schedule your appointment to see it today','0.4389','64','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Lake Livingston Area','Central Electric','1','FOREST COVE #1, BLOCK 3, LOT 4 & 5, ACRES .4389','Subdivision Lot,Water View','19118','Appraisal District','','200','0','','1','Electric Oven','0','','','Electric Cooktop','','Other','101 - Coldspring-Oakhurst Consolidated','JAMES STREET ELEMENTARY SCHOOL','COLDSPRING-OAKHURST HIGH SCHOOL','LINCOLN JUNIOR HIGH SCHOOL','Appointment Required','Seller','2','Traditional','Forest Cove #1','2274','1.5516','Public Sewer,Public Water','1975','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','214952775','1669054882','214952775','2022-11-20T07:23:18.970','14182043','Sandra Vargas','REALM Real Estate Professional','','','30.255324','-95.054010','14','77327','4','150000.00','Active','County Road 340','2144','','Cleveland','2','0','3','1386','Single-Family','The possibilities are endless with this stunning, 7 years young, 3 bedroom, 2 bathroom home on half an acre! An inviting, open kitchen concept to the dining area and family room is perfect for entertaining and family gatherings Ample storage space in the kitchen and enjoy extra counter space with the useful kitchen island! The utility room is off the kitchen and leads to the backyard. Storage shed in the backyard stays. Plenty of space to make this rare find your own. Schedule your appointment today!','0.5','52','Clayton','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Cleveland Area','Central Electric','0','BELLA VISTA, SEC 5, BLOCK 33, LOT 1320, ACRES 0.5000','Cleared,Subdivision Lot','21780','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','100 - Cleveland','EASTSIDE ELEMENTARY SCHOOL','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Other Style','Bella Vista','817','1.6917','Public Sewer,Public Water','2015','Seller'); --> 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','214972304','1669054882','214972304','2022-11-20T08:23:10.937','89421689','Nola Lusk','A\'Lon Realty Co.','','','29.892715','-95.223020','6','77044','3','140000.00','Active','Greenglen','11918','Drive','Houston','2','0','3','1080','Single-Family','Great investment property already tenant occupied. Feel free to drive by the property to view, but do not disturb tenant. Please just serious Investors only. No showings without a written offer and proof of funds. You may write your offer subject to viewing interior. Buyers to verify room measurements, we have provided estimates only. PLEASE DO NOT DISTURB THE TENANTS!','0.101','2','','','','','Owner/Agent,Sellers Disclosure,Tenant Occupied','','','','Northeast Houston','Central Electric','1','LT 23 BLK 8 GREENSBROOK SEC 1 R/P','Subdivision Lot','4400','Appraisal District','','200','0','','1','Electric Oven','0','','','Electric Range','','Composition','46 - Sheldon','GARRETT ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','MICHAEL R. NULL MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','Greensbrook Sec 01 R/P','4032','3.1593','Public Sewer,Public Water','2003','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','214978903','1669054882','214978903','2022-11-20T08:42:57.737','91357019','Julie Santiago','LennarVillageBldr-JaredTurner','','','29.518540','-95.783962','6','77471','9','380000.00','Active','Paloma Falls','3628','Lane','Rosenberg','3','1','4','2548','Single-Family','NEW! Lennar Fairway Collection \"Cantaron\" Plan with Brick Elevation \"G\" in Sendero! The largest single-story home at Fairway with a two-bay garage and storage space. The gourmet kitchen overlooks the living space and covered patio. There is plenty of flexibility for family living with three secondary bedrooms and a study, and the owner’s suite with an en-suite bathroom is tucked away for privacy. *HOME ESTIMATED TO BE COMPLETE, JANUARY, 2023*','','30','Lennar','','','','Mud,Other Disclosures','1','','0','Fort Bend South/Richmond','Central Gas','1','SEC 0005 BLK 001 LOT 016','Subdivision Lot','','','','756','1','To Be Built/Under Construction','2','','0','','','','','Composition','33 - Lamar Consolidated','MEYER ELEMENTARY SCHOOL (LAMAR)','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Sendero','','3.09','Water District','2022','Builder'); --> New record created successfully