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-10-06T07:23:04.970' ,`MLSNumber` = '59473791' ,`ListAgentFullName` = 'Todd Anderson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.720278' ,`Longitude` = '-95.061120' ,`PhotoCount` = '10' ,`PostalCode` = '77351' ,`RoomCount` = '2' ,`ListPrice` = '48000.00' ,`Status` = 'Active' ,`StreetName` = 'Jaycrest' ,`StreetNumber` = '383' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come enjoy this 512\' Tiny house on two cleared lots. 7615 Sq Ft with Electric, Plumbing and Culvert. Inside Lake Livingston Village Subdivision, with LOW HOA fee. Subdivision offers 2 boat ramps and community pool.' ,`Acres` = '0.0872' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Space Heater,Wall Heater' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE LIVINGSTON VILLAGE SECTION 8 LOT 186' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '48' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Lake Livingston Village Sectio' ,`TaxAmount` = '356' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072421' WHERE `Matrix_Unique_ID` = '208124493' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T06:16:30.160' ,`MLSNumber` = '53927809' ,`ListAgentFullName` = 'Suzan Zachariah' ,`ListOfficeName` = 'The Local Agents Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.959687' ,`Longitude` = '-95.294363' ,`PhotoCount` = '40' ,`PostalCode` = '77541' ,`RoomCount` = '2' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingfish' ,`StreetNumber` = '8' ,`StreetSuffix` = 'Lane' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This may be Kokomo. 8 Kingfish special home located in Bridge Harbor. The new owner will enjoy the choices of staying at home & enjoying the pool & jet tub as well as a great restaurant at the marina, or beach days 3 minutes away to Surfside Beach. You may also decide to board the boat & take advantage of the Intracoastal & Gulf/Bays for fishing. On two lots in Bridge Harbor across from the marina this home has one lot with a pool and deck, and one of the lots with a 2/2 home with a bath downstairs by the pool as well as a \"garage\". The landscaped home has a large deck facing Bridge Harbor Marina. When you walk into the home, you are in an open living area with the kitchen. To the rear is a utility room with storage, a primary bedroom with a bathroom with a tiled shower to the right, and to the left a the same but mirrored bedroom and bathroom. This home has a private feel and has room to grow. \"That\'s where we wanna go, way down in Kokomo.\" Staging items&some pictures not included' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BRIDGE HARBOR (A0051 DIV 8 (B C I C)) (FREEPORT) LOT 8 & 9' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Bridge Harbor' ,`TaxAmount` = '' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072421' WHERE `Matrix_Unique_ID` = '208565980' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T06:39:43.707' ,`MLSNumber` = '34165061' ,`ListAgentFullName` = 'Lisa Weeks' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.141651' ,`Longitude` = '-95.079042' ,`PhotoCount` = '15' ,`PostalCode` = '77357' ,`RoomCount` = '6' ,`ListPrice` = '239999.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 3562' ,`StreetNumber` = '36' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3/2 MFG HOME ON 2.37 ACRES WITH PORCH, NEW STORAGE SHED, FRESH PAINT INSIDE AND OUT, NEW DISHWASHER, RANGE VENT, SPLIT FLOOR PLAN, PRIMARY BATH HAS TUB AND SEPARATE SHOWER, 2ND BATH HAS TUB/SHOWER COMBO. LARGE LIVING AND DINING COMBO WITH FIREPLACE IN LIVING AREA. LARGE PRIMARY BEDROOM WITH WALK IN CLOSET. KITCHEN HAS BUILT IN BOOKCASE AND DESK AREA, ISLAND WITH BAR STOOL SEATING. MINUTES FROM GRAND PKWY 99. PROPERTY DOES NOT FLOOD, HAS LOW TAXES AND NO HOA AND MUCH MUCH MORE' ,`Acres` = '2.37' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MAGNOLIA ESTATES, SEC 2, LOT 36, ACRES 2.37' ,`LotDesciption` = 'Cleared' ,`LotSize` = '103237' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Magnolia Estates, Sec 2' ,`TaxAmount` = '1398' ,`TaxRate` = '1.8013' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072421' WHERE `Matrix_Unique_ID` = '208710335' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:19:29.150' ,`MLSNumber` = '24763530' ,`ListAgentFullName` = 'Brianna Tieperman' ,`ListOfficeName` = 'Keller Williams Coastal Bend' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.028158' ,`Longitude` = '-97.076288' ,`PhotoCount` = '11' ,`PostalCode` = '78382' ,`RoomCount` = '4' ,`ListPrice` = '409999.00' ,`Status` = 'Active' ,`StreetName` = 'Redwood' ,`StreetNumber` = '638' ,`StreetSuffix` = '' ,`City` = 'Rockport' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1912' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction is ready for you to come home to her! This elegant three bedroom, two and a half bath hits every possible checkmark you’d like to see in a home. Enter through your gorgeous eight ft door to an entryway featuring a 12 to 13 ft drop ceiling. Each bedroom features 9 to 10 ft drop ceilings. Six ft windows throughout the home makes for beautiful natural light wherever you go. Your custom kitchen features under Cabinet Lighting, all appliances and tons more. Beautiful master bedroom with a walk in shower, jacuzzi tub and built in shelves through closet. Control your built in security system, speakers or TVs from the Smart Hub located in the laundry room. Spend evenings on your covered back patio grilling and watching the big game. Home is estimated to be completed at the beginning of July. Upon completion: fully fenced and sod will be laid in the front and back yard. The list of upgrades, add ons and custom features goes beyond what we have room for. Book your showing today!' ,`Acres` = '0.15' ,`Area` = '85' ,`BuilderName` = 'JP Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'OAK TERRACE, LOT 210' ,`LotDesciption` = 'Other' ,`LotSize` = '6500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '310 - Aransas County' ,`SchoolElementary` = 'LIVE OAK 1-3 LEARNING CENTER' ,`SchoolHigh` = 'ROCKPORT-FULTON HIGH SCHOOL' ,`SchoolMiddle` = 'ROCKPORT-FULTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oak Terrace' ,`TaxAmount` = '808' ,`TaxRate` = '1.7623' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665072421' WHERE `Matrix_Unique_ID` = '208800884' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:43:44.003' ,`MLSNumber` = '22247102' ,`ListAgentFullName` = 'Kristin Carter' ,`ListOfficeName` = 'Realty ONE Group Iconic' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.174452' ,`Longitude` = '-95.580897' ,`PhotoCount` = '49' ,`PostalCode` = '77382' ,`RoomCount` = '9' ,`ListPrice` = '555000.00' ,`Status` = 'Active' ,`StreetName` = 'Red Adler' ,`StreetNumber` = '7' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2488' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 1-story home is nestled on a quiet cul-de-sac lot in the prestigious neighborhood of Archwyck in Sterling Ridge area of The Woodlands. This home boasts an amazing open concept floor plan in all common living areas, archways, high ceilings, hard wood and tile flooring throughout and a spectacular view of your private backyard oasis. Covered outdoor living space with a luxurious pool/spa combo with waterslide and multiple waterfalls for those hot Texas days and nights. Private, Full outdoor bathroom for backyard entertaining convenience. This backyard is truly a dream for entertaining family and friends. Split floor plans offer separate Master bedroom with en-suite bath and closet overlooking the backyard oasis and private outdoor entry access. 3 Well appointed secondary bedrooms, one with full en-suite bath and closet, other two share a generously sized full bathroom. NEVER FLOODED!' ,`Acres` = '0.2667' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S969942 - WDLNDS VIL STERLING RIDGE 42, BLOCK 1, LOT 16' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '11616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'TOUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Sterling Ridge 42' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072421' WHERE `Matrix_Unique_ID` = '209395074' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:40:48.693' ,`MLSNumber` = '16918978' ,`ListAgentFullName` = 'Brian Silverberg' ,`ListOfficeName` = 'Silver Key Properties' ,`SellingAgentFullName` = 'Anthony Esmurria' ,`SellingOfficeName` = 'Texas Skyline Properties, LLC' ,`Latitude` = '29.798032' ,`Longitude` = '-95.440455' ,`PhotoCount` = '39' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '499900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Droxford' ,`StreetNumber` = '2310' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1581' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNIQUE opportunity to own move in condition all brick home on huge OVERSIZED lot greater than 12,000 sqft. Imagine the possibilities with all that space (garden, pool), and so close to downtown Houston/Galleria. Three bedrooms with new carpet and 2 full baths. Freshly painted walls and trim. Formal living and dining room. Den with beautiful glass french doors looking out on huge back yard. Kitchen with new oven, gas range, tiled back splash, granite counters and shaker cabinets. Utility with cabinets and elec/gas connections.' ,`Acres` = '0.1808' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 10 TIMBERGROVE MANOR SEC 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Timbergrove Manor 14' ,`TaxAmount` = '8784' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072421' WHERE `Matrix_Unique_ID` = '209592864' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:39:54.610' ,`MLSNumber` = '28927119' ,`ListAgentFullName` = 'Tod Franklin' ,`ListOfficeName` = 'DFWCityhomes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.660401' ,`Longitude` = '-95.578083' ,`PhotoCount` = '25' ,`PostalCode` = '77099' ,`RoomCount` = '9' ,`ListPrice` = '253000.00' ,`Status` = 'Active' ,`StreetName` = 'Windmark' ,`StreetNumber` = '11231' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2306' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large brick house w/ attached daycare unit; now remodeled. Roof, A/C, water heater all replaced 3-5 years ago. Additional partially covered patio plus covered storage area so big it spans the entire side of the house w/ electric and plumbing. All 4 bedrooms have 1 or 2 walk-in closets. Double wide & double length driveway. 2 Attics. Corner lot. Low HOA includes Pool, courts, playground, long trail. Never flooded/ no frozen pipes' ,`Acres` = '0.1198' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 3 BAYOU PLACE R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '5220' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '30' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'OLLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Bayou Place R/P' ,`TaxAmount` = '4354' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072422' WHERE `Matrix_Unique_ID` = '209820752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:37:41.280' ,`MLSNumber` = '24800071' ,`ListAgentFullName` = 'Tirey Counts' ,`ListOfficeName` = 'Monarch Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.975508' ,`Longitude` = '-95.664395' ,`PhotoCount` = '23' ,`PostalCode` = '77429' ,`RoomCount` = '4' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Halpren Falls' ,`StreetNumber` = '16211' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Buyer failed to get financing, and we are back on the market. Amazing 4 bedroom house with a pool. Huge primary bedroom on ground floor, three other bedrooms on second floor. The second floor has an expansive open \"loft\" space that can be used as a den, media room, game room or play area....' ,`Acres` = '0.1653' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 2 COLES CROSSING SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SAMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Coles Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072422' WHERE `Matrix_Unique_ID` = '209868350' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T06:23:55.457' ,`MLSNumber` = '3478936' ,`ListAgentFullName` = 'Suzan Zachariah' ,`ListOfficeName` = 'The Local Agents Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.943830' ,`Longitude` = '-95.298819' ,`PhotoCount` = '28' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Thunder' ,`StreetNumber` = '611' ,`StreetSuffix` = 'Road' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction! Beautiful!!!There are views off the back and the front decks. The front deck has the view of Thunder Rd beach. This is a favorite of families and surfers. The front deck has a pergola for partial cover. Walk into an open living area/kichen that pops with some cabinets having glass doors. To the left are two bedrooms and a bathroom with a shower and to the right, a master bedroom with an En suite bathroom with the laundry hookups. The back deck has access off the kitchen. I love the views from the back of the big ships coming into the turning basin. From the master bedroom, you can see the Surfside Bridge. Come see, but please excuse the continued work completing the home. You can\'t beat this home with its many upgraded finishes.' ,`Acres` = '0.1205' ,`Area` = '5' ,`BuilderName` = 'Davison Gulf Coast' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SURFSIDE BLK 559 LOT 1 (REPLAT) (A0051 F J CALVIT)' ,`LotDesciption` = 'Water View' ,`LotSize` = '5249' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Surfside Townsite' ,`TaxAmount` = '816' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665072422' WHERE `Matrix_Unique_ID` = '210504161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:37:01.220' ,`MLSNumber` = '58406452' ,`ListAgentFullName` = 'Michael Hernandez' ,`ListOfficeName` = 'Coldwell Banker Central- Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.826697' ,`Longitude` = '-95.425829' ,`PhotoCount` = '23' ,`PostalCode` = '77018' ,`RoomCount` = '10' ,`ListPrice` = '919900.00' ,`Status` = 'Active' ,`StreetName` = 'Gardenia' ,`StreetNumber` = '1035' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN READY! This remodeled home is in the highly desirable Garden Oaks neighborhood. The home has been reconfigured from its original floor plan to an open spacious floor plan. With a nicely redone kitchen, large primary suite, large primary bath with his and her vanity, stand up shower, with a large walk-in primary closet. The home has 10-foot-high ceilings in kitchen/dining/great room. Great room has huge windows that lookout to the beautiful, landscaped front yard. New mechanical, electrical and plumbing, Bosch stainless steel appliance package, detached garage wifi capable with breeze way. The home is sectioned to Garden Oaks Elementary School.' ,`Acres` = '0.2306' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Garden Oaks' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 33 BLK 52 GARDEN OAKS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10044' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Garden Oaks' ,`TaxAmount` = '10877' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072422' WHERE `Matrix_Unique_ID` = '210628583' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:00:51.723' ,`MLSNumber` = '35114588' ,`ListAgentFullName` = 'Cynthia Ramos' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804292' ,`Longitude` = '-94.893909' ,`PhotoCount` = '22' ,`PostalCode` = '77523' ,`RoomCount` = '5' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Euros' ,`StreetNumber` = '7623' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1872' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning home has a bright, open floor plan.The kitchen is stylish and functional, looking out over a spacious but cozy dining/living area. Natural light beams through the large windows featured in both the dining and living room. Perfect for entertaining, your loved ones will gather around the island and make memories! The floor plan features 4 spacious bedrooms and 2 full baths.The primary bathroom has a luxurious stand alone shower, while the secondary bathroom has a tub/shower combo.The backyard offers a covered patio that is perfect for relaxing outside at any time of the day.The front yard has easy access to shared mailboxes and a 2 car garage. This home also has Solar Panels to cut energy costs, which in this Texas heat is a plus! The community amenities include a walking trail, a unique playground, and picnic table seating. Also in construction, is a community pool with a relaxing walkable trail to access it. Schedule a showing today…. and don\'t let this one slip away!' ,`Acres` = '0.1492' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BLK 2 LOT 16 SOUTHWINDS SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '6498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '540' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwinds Sec 1' ,`TaxAmount` = '6641' ,`TaxRate` = '2.8882' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072422' WHERE `Matrix_Unique_ID` = '210965346' --> 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','211127826','1665072422','211127826','2022-10-06T07:57:54.130','62370119','Heather Fordham','Compass RE Texas, LLC','','','29.543063','-95.089708','8','77058','8','379900.00','Active','Davon','1706','Lane','Houston','2','0','4','2135','Single-Family','Welcome to 1706 Davon Ln located in the highly sought-after community of Nassau Bay located directly across from Space Center Houston. This charming single level home is comprised of four ample bedrooms and two tastefully updated baths both with double vanities and granite countertops. No carpet in this home with wood flooring throughout. The kitchen is the heart of this home with hand painted tile backsplash, recycled glass countertops, and pot filler for added convenience. This home is designed to entertain with formal living room and dining areas in addition to the large family room with vaulted ceiling and beams to create an open and airy feel. The backyard oasis includes a large,covered patio area and in-ground pool surrounded by lush landscaping, the perfect spot for rest and relaxation. All of this just step away from Howard L. Ward Park with beautiful views of Clear Lake and a short drive to Nassau Bay Peninsula Wildlife Park, Kemah Boardwalk, and Armand Bayou Nature Center.','0.2122','7','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Clear Lake Area','Central Electric','1','LT 6 BLK 34 NASSAU BAY SEC 6','Subdivision Lot','9243','Appraisal District','','250','0','','2','Electric Oven','1','In Ground','','Gas Range','','Composition','9 - Clear Creek','ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)','CLEAR CREEK HIGH SCHOOL','SPACE CENTER INTERMEDIATE SCHOOL','Temporarily No Showings','Appraisal District','1','English','Nassau Bay','7187','2.4882','Public Sewer,Public Water','1968','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:22:00.900' ,`MLSNumber` = '18126283' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711917' ,`Longitude` = '-95.853727' ,`PhotoCount` = '22' ,`PostalCode` = '77441' ,`RoomCount` = '10' ,`ListPrice` = '593909.00' ,`Status` = 'Active' ,`StreetName` = 'Kenton Place' ,`StreetNumber` = '5222' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3433' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LIKE NEW... Stunning One Story home in the heart of Cross Creek Ranch Master Planned Community. Featuring 4 bedrooms, 3 bathrooms, Game Room, Private study, PLUS a 3 CAR GARAGE- this home will not disappoint. Formal entry with tall ceilings, tile flooring, and a home office with new double doors are just some of the details you will notice upon entering. This beautiful floorplan offers a spacious living area with tall ceilings and a gas fireplace. Well laid out open kitchen with butler pantry, stainless steel appliances, under cabinet lighting, and center island. Expansive primary retreat with en-suite bath featuring dual sinks, separate shower, and soaking tub. The home backs to green space and walking trails. Oversized back and side yard. ROOM FOR A POOL! Fresh paint throughout! Light and Bright! New flooring in all bedrooms. Cross Creek Ranch features miles of walking and biking trails, community pools, tennis courts, pickle ball courts and other amenities. Exemplary KISD!' ,`Acres` = '0.2502' ,`Area` = '36' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK BEND AT CROSS CREEK RANCH SEC 6, BLOCK 1, LOT 13' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '10897' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JAMES E RANDOLPH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creek Bend At Cross Creek Ranch Sec 6' ,`TaxAmount` = '12411' ,`TaxRate` = '3.1375' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072422' WHERE `Matrix_Unique_ID` = '211194885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T06:52:00.753' ,`MLSNumber` = '79176188' ,`ListAgentFullName` = 'Christopher Phan' ,`ListOfficeName` = 'Truss Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834939' ,`Longitude` = '-95.409721' ,`PhotoCount` = '22' ,`PostalCode` = '77018' ,`RoomCount` = '6' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Abbadean' ,`StreetNumber` = '4805' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Martin Court located in Independence Heights built by Oracle City Homes. This privately gated urban modern farmhouse community consists of 16 units total units with twelve 2 story homes and four 3 story homes that each come with a private yard. Each unit has been professionally designed interiors raising the bar with high end standard features that come with each home. First floor living with an oversized island countertop with seating of 3 that overlooks the living room that leads you to your own private backyard. The dining area is nestled in it\'s own private section with oversized windows along the adjoining walls giving plenty of natural lighting. The primary bedroom features 10 ft high ceilings and oversized windows that leads you to your own primary ensuite with separate his/her sinks along each wall that welcomes you into your own stand alone tub and walk in shower and closet. This community is a must see combining luxury and privacy!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 1 Martin Court' ,`LotDesciption` = 'Other' ,`LotSize` = '1100' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Martin Court' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665072423' WHERE `Matrix_Unique_ID` = '211294448' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T06:03:00.840' ,`MLSNumber` = '44771584' ,`ListAgentFullName` = 'Mike Canary' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563754' ,`Longitude` = '-95.268807' ,`PhotoCount` = '21' ,`PostalCode` = '77581' ,`RoomCount` = '9' ,`ListPrice` = '284900.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '3219' ,`StreetSuffix` = 'Circle' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2039' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Start Your Family Traditions in this charming 4 -5 bedroom home. Located in the heart of Pearland, it offers one of the lowest tax rates & NO HOA or their fee. Inside has many recent updates like paint, carpet, wood grained vinyl plank floors & more. The Family Room offers beautiful library paneling & beautiful brick fireplace. The owners retreat offers walk in closet, separate shower + jetted bathtub. 3 guest bedrooms share an updated bathroom. The back covered patio was enclosed many years ago & makes a great game-room, home office or 5th bedroom. The fenced back yard offers a wood deck & 2 car detached garage. If you are looking for a Great Place to Call Home, this could be it. Hurry, it will sell fast.' ,`Acres` = '0.1607' ,`Area` = '5' ,`BuilderName` = 'Offenberger Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ALEXANDER LANDING SEC 4 (A0198 T J GREEN)(PEARLAND) BLK 3 LO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'C J HARRIS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Alexander Landing' ,`TaxAmount` = '4742' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072423' WHERE `Matrix_Unique_ID` = '211310845' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T06:21:49.770' ,`MLSNumber` = '25642561' ,`ListAgentFullName` = 'Suzan Zachariah' ,`ListOfficeName` = 'The Local Agents Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.947634' ,`Longitude` = '-95.288880' ,`PhotoCount` = '29' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '589500.00' ,`Status` = 'Active' ,`StreetName` = 'Seashell' ,`StreetNumber` = '314' ,`StreetSuffix` = 'Drive' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1645' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! It\'s time to buy beach homes! This is a great 3rd row location and home. It has a large front deck to enjoy with friends and family being close to the beach. The new owner will enjoy the bonus of having a back deck to relax. Sunrises and sunsets. Coming off the front deck you walk in to a large area with two gathering spots, a dining area with storage and opens to the kitchen to the left. Going to the rear, there is a large utility room with storage, to the right is the master suite with 2 closets and the bath has a spa tub, separate shower, and two sink vanity with recent updates. To left are two more bedrooms, a hall bathroom, and access to the back deck. New HVAC system is a bonus. This home has been a family home, but could be a rental.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SURFSIDE TOWNSITE SEC 3 (A0051 F J CALVIT) (SURFSIDE) BLK 2' ,`LotDesciption` = 'Water View' ,`LotSize` = '7610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Surfside Townsite Sec 3' ,`TaxAmount` = '' ,`TaxRate` = '2.48886' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072423' WHERE `Matrix_Unique_ID` = '211386912' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:26:00.213' ,`MLSNumber` = '82142569' ,`ListAgentFullName` = 'Melissa Rekoff' ,`ListOfficeName` = 'Luxe Living Group, LLC' ,`SellingAgentFullName` = 'Angel Webb' ,`SellingOfficeName` = 'Angel Webb Realty, LLC' ,`Latitude` = '29.493358' ,`Longitude` = '-95.126597' ,`PhotoCount` = '25' ,`PostalCode` = '77573' ,`RoomCount` = '6' ,`ListPrice` = '220000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Ewell' ,`StreetNumber` = '2518' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1251' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a home to make your own? You will want to see this 3 bedroom 2 bath split floor plan. You will find that you are welcomed in by the large open living to dining room space, you can drop your shoes and bags in the Mud nook as you enter. The kitchen offers lots of cabinets & counter space. The home has a rustic industrial vibe, with updated bathrooms, a large backyard with space to add a pool, pets to run, or kids to play. Shed out back for storage. Sold AS IS! Don\'t miss out!' ,`Acres` = '0.1679' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 9 PAGE 2 LOT 19 BLK 4 THE LANDING SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7315' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '230' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROSS ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Landing' ,`TaxAmount` = '3768' ,`TaxRate` = '2.2667' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072423' WHERE `Matrix_Unique_ID` = '211432314' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:59:17.357' ,`MLSNumber` = '75064319' ,`ListAgentFullName` = 'Brian Brookins' ,`ListOfficeName` = 'Boulevard Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.889195' ,`Longitude` = '-95.568808' ,`PhotoCount` = '38' ,`PostalCode` = '77040' ,`RoomCount` = '9' ,`ListPrice` = '339500.00' ,`Status` = 'Active' ,`StreetName` = 'Wall' ,`StreetNumber` = '16302' ,`StreetSuffix` = 'Street' ,`City` = 'Jersey Village' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2141' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Live on Wall Street! Well maintained and ready for its new owners! Located in a desirable area of Jersey Village and within minutes of everything Jersey Village has to offer (see map in photos). The multiple bonus areas give this home flexibility to fit any lifestyle. The home design allows for optimal privacy from the street but with an abundance of natural light from the double pane windows looking onto the brick paver patio and spacious back yard. The sizeable eat in kitchen with pass through bar into the living area allow for open concept living with enough separation for the chef. *Foundation Assessed 8/22-No issues revealed *Roof Assessed 8/22-General maintenance items identified and all fixed *New garbage disposal 9/22 *All interior cabinets, doors, and trim freshly painted 8/22. *Washer/Dryer and stainless kitchen appliances (oven, microwave, dishwasher) all less than 4 years old *Never flooded-per the owner *Water heater, furnace, and fireplace are all gas.' ,`Acres` = '0.2296' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Jersey Village' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 23 BLK 40A JERSEY VILLAGE COUNTRY CLUB ESTATES SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POST ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Club Estates' ,`TaxAmount` = '6167' ,`TaxRate` = '2.7758' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072423' WHERE `Matrix_Unique_ID` = '211434421' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:02:31.173' ,`MLSNumber` = '73608340' ,`ListAgentFullName` = 'Morad Fiki' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.167271' ,`Longitude` = '-95.618223' ,`PhotoCount` = '35' ,`PostalCode` = '77486' ,`RoomCount` = '8' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Riverside' ,`StreetNumber` = '2291' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the beautiful resort community of COLUMBIA LAKES! This 4 BEDROOM, 2.5 BATH SINGLE STORY home is within proximity to many highways giving its owner easy access to north to HOUSTON or south to the BEACH and wildlife refuge areas. Located in a gated community, with 24-hour manned security, COLUMBIA LAKES also offers exceptional amenities both inside and outside your home to bring luxury and convenience to your life. Home amenities include a FRONT COVERED PORCH and a BACK COVERED PATIO, STUDY, KITCHEN WITH ISLAND AND PANTRY, and BREAKFAST AREA. Primary bath has DOUBLE SINKS, SOAKING TUB + SEPARATE SHOWER. Beautiful chandeliers throughout, luxury everywhere you look! Area amenities include an 18-hole, 7,000-yard golf course, an 8-court championship tennis complex, a 300-acre lake stocked with Trophy Bass for your fishing pleasure and a the picturesque Texas oak trees and crystal-clear lakes. This home is waiting for your personal touches to make it yours.est completion 08/31.' ,`Acres` = '0.2659' ,`Area` = '5' ,`BuilderName` = 'Altaie Corp' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COLUMBIA LAKES SEC 1 (A0133 M VARNER) BLK 1 LOT 3' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '11583' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Columbia Lakes' ,`TaxAmount` = '304' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072423' WHERE `Matrix_Unique_ID` = '211564481' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T06:02:17.113' ,`MLSNumber` = '53819412' ,`ListAgentFullName` = 'Mike Canary' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = 'Mike Canary' ,`SellingOfficeName` = 'UTR TEXAS, REALTORS' ,`Latitude` = '29.569936' ,`Longitude` = '-95.037600' ,`PhotoCount` = '27' ,`PostalCode` = '77586' ,`RoomCount` = '9' ,`ListPrice` = '339900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Laughing Gull' ,`StreetNumber` = '2530' ,`StreetSuffix` = 'Circle' ,`City` = 'Seabrook' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2506' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Start your family traditions in this charming 4/5 bedroom. Located in gated neighborhood Pelicans Nest, it\'s located on a Cul-de-sac lot. Inside looks like a model home, beautiful vinyl plank throughout the primary bedroom & living area w/carpet in the bedrooms. Tile floors in the bathrooms & kitchen area. The two story entry foyer has plant ledge & is next to the elegant dining room w/crown molding & chair railing. The granite kitchen/breakfast area overlook spacious family room which is next to the half bath & Home Office/5th bedroom. Upstairs offers a large landing area w/utility closet centrally located by 3 children\'s bedroom & the primary bedroom. The primary bathroom has double sinks, large soaker tub, separate shower, big walk-in closet w/hidden room for storage. The fenced back yard offers an extended patio plus a large storage shed. Low Tax rate, No MUD Tax, X-500 year Flood Zone = Lower Payments. Hurry, it\'s nice.' ,`Acres` = '0.1477' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 2 PELICANS NEST' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6435' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '45' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pelicans Nest' ,`TaxAmount` = '6139' ,`TaxRate` = '2.2905' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072424' WHERE `Matrix_Unique_ID` = '211568863' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:41:44.213' ,`MLSNumber` = '61898927' ,`ListAgentFullName` = 'Juan Barron' ,`ListOfficeName` = 'RE/ImageProperties and Investm' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.803953' ,`Longitude` = '-95.142382' ,`PhotoCount` = '28' ,`PostalCode` = '77530' ,`RoomCount` = '5' ,`ListPrice` = '189000.00' ,`Status` = 'Active' ,`StreetName` = 'Dell Dale' ,`StreetNumber` = '1507' ,`StreetSuffix` = 'Street' ,`City` = 'Channelview' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '947' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for your first home? This one is it! Floors (wood & tile), granite in the kitchen. The bedrooms size need to be verified. This backyard is big enough for all the activities and you will feel secure. HOA includes pool and playground. A must see!' ,`Acres` = '0.132' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S 44 FT OF LT 10 & N 6 FT OF LT 11 BLK 3 STERLING GREEN SEC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'HAMBLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'JOHNSON JUNIOR HIGH' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Green Sec 09' ,`TaxAmount` = '2746' ,`TaxRate` = '2.518' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072424' WHERE `Matrix_Unique_ID` = '211658345' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:37:01.470' ,`MLSNumber` = '74286801' ,`ListAgentFullName` = 'Britni Haley' ,`ListOfficeName` = 'Britni Haley' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.944993' ,`Longitude` = '-95.298031' ,`PhotoCount` = '21' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Texas' ,`StreetNumber` = '614' ,`StreetSuffix` = 'Street' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beach cottage will make the perfect primary home, investment property, or vacation getaway! Take your vision and make it a reality, priced with interior updates in mind! It has great indoor and outdoor living spaces to enjoy after a long day at the beach. The expanded deck gives you plenty of room to spread out and soak up the views of the Gulf, the large ships coming into port, stunning sunsets over the intracoastal, wetlands full of wildlife, and the Surfside bridge. This quiet part of the village offers tranquil beachside living with a short walk to the beach, boat ramp, jetty park, Ft. Velasco museum, bird & butterfly trail, splash pad, restaurants, and more!! Enter from the deck to the open living area. The master suite is to the right of the living room, while the guest bedroom and bathroom are to the right. Currently occupied, so be sure to call ahead. Motivated Seller!' ,`Acres` = '0.1478' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'SURFSIDE BLK 550 LOT 9 (A0051 F J CALVIT)' ,`LotDesciption` = 'Water View' ,`LotSize` = '6438' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Surfside' ,`TaxAmount` = '2399' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072424' WHERE `Matrix_Unique_ID` = '211659600' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:28:16.127' ,`MLSNumber` = '27873136' ,`ListAgentFullName` = 'Lemorra Carter' ,`ListOfficeName` = 'Priority One Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.647230' ,`Longitude` = '-95.138382' ,`PhotoCount` = '17' ,`PostalCode` = '77505' ,`RoomCount` = '6' ,`ListPrice` = '287000.00' ,`Status` = 'Active' ,`StreetName` = 'Heathfield' ,`StreetNumber` = '4210' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HOME SWEET HOME!!! Meticulously maintained one- story home located in the sought-after DPISD schools in the Village Grove neighborhood. Brand new upgraded floors in the bedrooms and brand new attic stairs. This home has a spacious kitchen that is open to the living and dining rooms with granite counter tops. Primary bedroom has updated the bathroom newly tiled shower and tub brand new toilet and granite counter tops with lots of storage space along with a nice walk-in closet. The secondary bathroom is updated as well with nice tile, paint, granite counter tops. This home has a new roof (2018) and has been completely re-piped along with a new water heater(2019) and new gutters all around. Hurry and book your viewing today!!!' ,`Acres` = '0.1663' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 VILLAGE GROVE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7245' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'FAIRMONT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Grove Sec 01' ,`TaxAmount` = '6053' ,`TaxRate` = '2.8798' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072424' WHERE `Matrix_Unique_ID` = '211692528' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:54:05.470' ,`MLSNumber` = '71753648' ,`ListAgentFullName` = 'Denny White' ,`ListOfficeName` = 'RE/MAX American Dream' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.670913' ,`Longitude` = '-95.105392' ,`PhotoCount` = '41' ,`PostalCode` = '77536' ,`RoomCount` = '11' ,`ListPrice` = '422000.00' ,`Status` = 'Active' ,`StreetName` = 'Graceland' ,`StreetNumber` = '4218' ,`StreetSuffix` = 'Drive' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home! This is a beautiful Gehan Redwood Home, the only unique floor plan in the neighborhood. Tons of upgrades! Whirlpool appliances, 2 Lennox AC units, surround sound, wood flooring, granite countertops, and upgraded stone fireplace, upgraded lighting, bronze doorknobs and restroom fixtures, iron spindles. Extra large covered back patio with surround sound and the only house in the neighborhood with an outdoor fireplace! 5 miles from Fairway plaza and within 10 minutes from Beltway 8 and Hwy 225. No back neighbors, never flooded and extra side yard.' ,`Acres` = '0.1263' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 THE ENCLAVE AT EAST MEADOW SEC 1 AMEND' ,`LotDesciption` = 'Corner' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'COLLEGE PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave/East Mdw Sec 01' ,`TaxAmount` = '7837' ,`TaxRate` = '2.7308' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072424' WHERE `Matrix_Unique_ID` = '211872228' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:13:31.690' ,`MLSNumber` = '53540516' ,`ListAgentFullName` = 'Nicole Shields' ,`ListOfficeName` = 'CRI Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.425312' ,`Longitude` = '-95.313273' ,`PhotoCount` = '12' ,`PostalCode` = '77378' ,`RoomCount` = '4' ,`ListPrice` = '679000.00' ,`Status` = 'Active' ,`StreetName` = 'Quiet Springs' ,`StreetNumber` = '31' ,`StreetSuffix` = 'Trail' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3307' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come home to your own slice of paradise! Peach Creek Farms is a new custom home development in Willis with 32 beautiful 1-to-6-acre parcels. Modern farmhouse design built by Hycraft Homes and boasts beautiful finishings throughout. Well appointed layout has 4 bedrooms , large family room with fireplace and sliding doors to back patio, spacious kitchen with large island, shaker white kitchen cabinets with matte black hardware, large walk in pantry. Luxurious primary suite showcases a large walk in shower, vessel soaking tub, amble cabinets/vanities, super closet. Upstairs game room with 2 full baths. 3 full car garage.Home is currently being built with expected completion in November 2022.' ,`Acres` = '1' ,`Area` = '64' ,`BuilderName` = 'Hycraft Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PEACH CREEK FARMS, LOT 30, ACRES 1.0' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'EDWARD B. CANNAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Peach Creek Farms' ,`TaxAmount` = '1175' ,`TaxRate` = '1.9577' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665072425' WHERE `Matrix_Unique_ID` = '211926122' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:50:37.367' ,`MLSNumber` = '85336123' ,`ListAgentFullName` = 'Pravin Sonthalia' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.005908' ,`Longitude` = '-95.493717' ,`PhotoCount` = '35' ,`PostalCode` = '77068' ,`RoomCount` = '6' ,`ListPrice` = '323500.00' ,`Status` = 'Active' ,`StreetName` = 'Stoney Oak' ,`StreetNumber` = '3623' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful fully renovated property in August 2022 is nestled under mature trees lush landscaping on a corner lot. This home features 4 bedrooms , 3 full bath w/wet bar , breakfast area , separate dining room\r\nwith 2 Bedrooms Down !!! 3 Car Garage with High Ceilings in Family Room. Upon entering the home you are greeted with new and fresh interior paint, new laminate floors. The kitchen has been updated with new appliances and granite countertop, backsplash sink and abundance of cabinet space . The master bath has a huge Walk in shower with 2 sinks and closet . The downstairs A/C unit is also new and updated in August 2022.The backyard has a huge covered patio . All the electrical and plumbing fixtures have been updated as well with a new garage opener. The property is located close to all major highways like 249 and Beltway 8 and close to shopping malls and restaurants.' ,`Acres` = '0.2204' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 10 OLDE OAKS SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '445' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olde Oaks' ,`TaxAmount` = '5131' ,`TaxRate` = '2.3342' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072425' WHERE `Matrix_Unique_ID` = '211975157' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:56:39.907' ,`MLSNumber` = '34846792' ,`ListAgentFullName` = 'Amber Quiroz' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.214318' ,`Longitude` = '-95.423391' ,`PhotoCount` = '46' ,`PostalCode` = '77385' ,`RoomCount` = '14' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Yearling Place' ,`StreetNumber` = '9961' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2587' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller! Beautifully built, HUGE 5 bedroom, 3 bathroom brick home featuring a formal dining room, 2 car garage, spacious backyard, impressive kitchen with granite countertops. Primary bedroom is upstairs and includes a huge bathroom with 2 sinks and lots of closet space! The home has a custom, built-in dog house for your pooch! The dog suite is 4\'x8\'. Save money with the solar panels, which pays for the lights and water heater electricity usage. The Tesla battery stores energy for outages. The Tesla app allows the homeowner to see how much the electricity company pays back. The neighborhood park is a short walk away and includes a playground, splash pad, pool, and picnic area. The Woodlands Mall, Market Street, and Medical Center are all less than 10 minutes away. There is an HEB, Starbucks, and several restaurants less than 5 minutes away. This home is built in a location for a quiet home life, & convenient access to everything Conroe and The Woodlands has to offer.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric,Solar Assisted' ,`HOAMandatory` = '1' ,`Legal` = 'S720810 - MONTGOMERY CREEK RANCH 10, BLOCK 2, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6403' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Creek Ranch 10' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072425' WHERE `Matrix_Unique_ID` = '212040189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:40:37.633' ,`MLSNumber` = '24462090' ,`ListAgentFullName` = 'Troy Cothran' ,`ListOfficeName` = 'Victory Properties, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.530994' ,`Longitude` = '-95.057972' ,`PhotoCount` = '40' ,`PostalCode` = '77573' ,`RoomCount` = '7' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'Bent Tree' ,`StreetNumber` = '2713' ,`StreetSuffix` = 'Trail' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2979' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seller just reduced price and now is one of the best buys in the entire neighborhood so now is your turn to take a peek and see what all this home has in store for you!\r\nWelcome to your address! This 3-4 bedroom 2.5 bath has a beautiful brick tile entry replaced in 2020. Check out the see-through fireplace in the living room looking into the game room area. The primary bedroom (downstairs) has a separate shower and garden tub. The formal dining area has a nice little courtyard area to enjoy, one of the upstairs bedrooms have balconies to enjoy sitting out on those beautiful afternoons. Enjoy swimming in your own pool that backs up to the subdivision park with pool, volleyball and tennis & basketball courts. it\r\nRoom sizes appx. Buyer to verify' ,`Acres` = '0.263' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 PAGE 6 LOT 2 BLK 4' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '11456' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Shore Harbour' ,`TaxAmount` = '7427' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072425' WHERE `Matrix_Unique_ID` = '212208849' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T06:32:57.147' ,`MLSNumber` = '22638067' ,`ListAgentFullName` = 'Kashif Gaddi' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855961' ,`Longitude` = '-95.818923' ,`PhotoCount` = '34' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Pampus Prairie' ,`StreetNumber` = '5714' ,`StreetSuffix` = 'Road' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Imagine your own lakefront home with direct access from your backyard. This recently painted 2019 built home offers great curb appeal and sits on a lakefront lot! Luxury vinyl plank floors greet you as you walk on all the way to the back door. Kitchen offers black energy appliances including refrigerator with 2022 installed stainless-steel dishwasher(not pictured). Primary bedroom is tucked away from the other bedrooms offering privacy and a great view of the lake. The secondary bedrooms come upgraded with new wood tiles. The backyard is the perfect place to unwind and enjoy the lovely views of the lake. Walk out of your backyard for a walk or run on the walking trail around the lake.' ,`Acres` = '0.1056' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 3 KATY CROSSING SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Katy Xing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072425' WHERE `Matrix_Unique_ID` = '212279888' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T06:18:36.800' ,`MLSNumber` = '70082079' ,`ListAgentFullName` = 'Suzan Zachariah' ,`ListOfficeName` = 'The Local Agents Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.959655' ,`Longitude` = '-95.275840' ,`PhotoCount` = '32' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'West Palm' ,`StreetNumber` = '119' ,`StreetSuffix` = 'Street' ,`City` = 'Surfside Beach' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'More pictures coming. Stunning third row home in a brand new beachfront subdivision. Great beach, views, and amazing floorplan. The wide deck with views to the beach will strike your fancy right off, then walk-in to the open kitchen/dining-room/living area with high ceilings and views plus a 1/2 bath for guest, and a downstairs bedroom with a private bathroom with tiled bathtub. Upstairs is an extra large bedroom with built in beadboard wardrobe with drawers, an elegant tiled walk-in shower and large walk-in closet as well and access to the upper deck. The adjacent bedroom has a private bathroom with tiled shower, a built in beadboard wardrobe access to the upper deck and views of the beach. The 4th bedroom is to the rear off the hall adjacent to the fourth bathroom with a tiled shower. Come see this popular floorplan in a subdivision with a walk-over to the beach.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Howard Street Condos' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WEST PALM VILLAGE (BCIC DIV 1) (SURFSIDE) LOT 3' ,`LotDesciption` = 'Water View' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'West Palm Village Bcic Div 1' ,`TaxAmount` = '4841' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665072425' WHERE `Matrix_Unique_ID` = '212383343' --> 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','212403912','1665072426','212403912','2022-10-06T06:11:53.247','11233331','Ruth Romero','NB Elite Realty','','','29.792754','-95.356396','14','77009','5','250000.00','Active','Cochran','3515','Street','Houston','1','0','2','972','Single-Family','Looking for an investment property? This house has good bones, is cozy and in a great location!\r\nAre you a first time home buyer? This house is waiting for your personal touches and offers a nice back yard!\r\n\r\nNearby restaurants, parks and schools. Easy access to 45, 610 and minutes to downtown.','0.1148','9','','','','','Other Disclosures,Sellers Disclosure','0','','','Northside','Other Heating','0','LT 7 BLK 40 RYON','Subdivision Lot','5000','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','MARTINEZ C ELEMENTARY SCHOOL','NORTHSIDE HIGH SCHOOL','MARSHALL MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Ryon','3600','2.3307','Public Sewer,Public Water','1935','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:11:29.840' ,`MLSNumber` = '16372201' ,`ListAgentFullName` = 'Kayla Houston' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.939716' ,`Longitude` = '-95.668063' ,`PhotoCount` = '10' ,`PostalCode` = '77095' ,`RoomCount` = '4' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Agate Canyon' ,`StreetNumber` = '11526' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2587' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This exquisite one-story home is located in the gated community of Ruby Canyon. With detail and character throughout, this home offers the ultimate in an open living concept! Beautiful, lush landscaping. Newly updated kitchen with island and breakfast bar. Large walk-in laundry room, ample closet space, and a split floor plan. The oversized back patio offers an outdoor oasis to enjoy for the ultimate in relaxation and entertaining.' ,`Acres` = '0.1938' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 STONE GATE SEC 4' ,`LotDesciption` = 'Other' ,`LotSize` = '8443' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1140' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LAMKIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Gate Sec 04' ,`TaxAmount` = '6882' ,`TaxRate` = '2.561' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072426' WHERE `Matrix_Unique_ID` = '212413769' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:45:05.140' ,`MLSNumber` = '23709776' ,`ListAgentFullName` = 'Darren Morris' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.779925' ,`Longitude` = '-95.385819' ,`PhotoCount` = '31' ,`PostalCode` = '77009' ,`RoomCount` = '8' ,`ListPrice` = '1135000.00' ,`Status` = 'Active' ,`StreetName` = 'Voight' ,`StreetNumber` = '1037' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2925' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous, top quality new construction, in a great location! Right out the backyard is Stude Park, with access to the extensive Houston hike and bike trails. Minutes from Downtown, the Galleria, the Medical Center-in the middle of it all! Walking distance to many of the Heights famous eateries and shopping. Features include Hardie Plank, PEX water system, Radiant Barrier in attic, smart thermostats, high end high efficiency HVAC systems, Double-paned low E windows, Builder Warranty, Oversized Garage, Security system wired, Surround Sound wired, Skylights for lots of natural light, and much more. Please see attached features list for complete list. Walking distance to BB\'s Tex-Orleans, Christian\'s Tailgate, Tacos A Go Go, Onion Creek, Stude Park, MKT Trail, and much more. Completed Construction Sept 2022!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Nebula' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 2 BLOCK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3125' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665072426' WHERE `Matrix_Unique_ID` = '212414088' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:44:37.497' ,`MLSNumber` = '67290035' ,`ListAgentFullName` = 'Darren Morris' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780006' ,`Longitude` = '-95.385953' ,`PhotoCount` = '32' ,`PostalCode` = '77009' ,`RoomCount` = '6' ,`ListPrice` = '1135000.00' ,`Status` = 'Active' ,`StreetName` = 'Voight' ,`StreetNumber` = '1039' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2925' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous, top quality new construction, in a prime location! Right out the backyard is Stude Park, with access to the extensive Houston hike and bike trails. Minutes from Downtown, the Galleria, the Medical Center-in the middle of it all! Walking distance to many of the Heights famous eateries and shopping. Features include Hardie Plank, PEX water system, Radiant Barrier in attic, smart thermostats, high end high efficiency HVAC systems, Double-paned low E windows, Builder Warranty, Oversized Garage, Security system wired, Surround Sound wired, Skylights for lots of natural light, and much more. Please see attached features list for complete list. Walking distance to BB\'s Tex-Orleans, Christian\'s Tailgate, Tacos A Go Go, Onion Creek, Stude Park, MKT Trail, and much more. Construction is complete September 2022.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Nebula' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 1 BLOCK 2 USENER ADDITION' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3125' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665072426' WHERE `Matrix_Unique_ID` = '212414161' --> 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','212442497','1665072426','212442497','2022-10-06T07:22:56.923','81497609','Ruth Romero','NB Elite Realty','','','29.792911','-95.356322','13','77009','5','250000.00','Active','Collingsworth','1118','Street','Houston','1','0','2','1053','Single-Family','Looking for an investment property? This house has good bones and in a great location!\r\nAre you a first time home buyer? This home awaits your personal touches, offers a covered patio and sits on a corner lot!\r\n\r\nNearby restaurants, parks and schools. Close proximity to 45, 610 and minutes to downtown.','0.1148','9','','','','','Other Disclosures,Sellers Disclosure','0','','','Northside','Other Heating','0','LT 6 BLK 40 RYON','Subdivision Lot','5000','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','MARTINEZ C ELEMENTARY SCHOOL','NORTHSIDE HIGH SCHOOL','MARSHALL MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Ryon','3815','2.3307','Public Sewer,Public Water','1945','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:05:37.250' ,`MLSNumber` = '90879244' ,`ListAgentFullName` = 'Maricela Olivo' ,`ListOfficeName` = 'J. Lindsey Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.728997' ,`Longitude` = '-95.359793' ,`PhotoCount` = '7' ,`PostalCode` = '77004' ,`RoomCount` = '3' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Sauer' ,`StreetNumber` = '3403' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1769' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0608' ,`Area` = '4' ,`BuilderName` = 'Navarro Constuction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 9B & 10A BLK 4 FOREST HOME' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2647' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Home' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665072426' WHERE `Matrix_Unique_ID` = '212450798' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:26:17.497' ,`MLSNumber` = '35577722' ,`ListAgentFullName` = 'Kristi Henry' ,`ListOfficeName` = 'Galveston Vacation Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.401851' ,`Longitude` = '-94.898020' ,`PhotoCount` = '31' ,`PostalCode` = '77590' ,`RoomCount` = '4' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = '18th' ,`StreetNumber` = '221' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1129' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! You will fall in love with this charming home and all of its modern farmhouse finishes! Entire home has been completely updated and redesigned. Fresh paint inside & out. New windows throughout the entire home, recessed lighting, new fans, fixtures, new pot filler faucet already installed above stove range, farmhouse sink, oversized barn door in living area leading to primary bedroom, NEW HVAC 2022, NEW ROOF 2022, NEW FLOORS, NEW PLUMBING! Bathroom beautifully designed & is a complete remodel. Quartz countertops & backsplash, new kitchen shaker cabinets, stainless steel appliances, foundation updated in 2022 and comes with warranty. Laundry room inside home for your convenience. Don\'t forget your pets, plenty of backyard room for them with a new concrete pad in the backyard for some BBQ and entertaining. This one is your perfect getaway just minutes away from fishing, dining and schools. NO HOA, NEVER FLOODED. Schedule your appointment today. THIS ONE WILL NOT LAST!' ,`Acres` = '0.1435' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 167 D RICHARDSON SUR LOT 3 BLK 411 TEXAS CITY' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Texas City 5th Division' ,`TaxAmount` = '1317' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1943' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072426' WHERE `Matrix_Unique_ID` = '212558056' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:02:12.000' ,`MLSNumber` = '22921620' ,`ListAgentFullName` = 'Jose Portillo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Jeremy Harris' ,`SellingOfficeName` = 'Nextgen Real Estate Properties' ,`Latitude` = '29.784454' ,`Longitude` = '-95.330777' ,`PhotoCount` = '14' ,`PostalCode` = '77026' ,`RoomCount` = '7' ,`ListPrice` = '124000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Russell' ,`StreetNumber` = '2416' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'investment opportunity' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 15 HOME' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DOGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Home' ,`TaxAmount` = '1204' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072427' WHERE `Matrix_Unique_ID` = '212610588' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:57:42.993' ,`MLSNumber` = '61397191' ,`ListAgentFullName` = 'Cody Scurlock' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.673651' ,`Longitude` = '-95.134068' ,`PhotoCount` = '48' ,`PostalCode` = '77536' ,`RoomCount` = '8' ,`ListPrice` = '394000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Bend' ,`StreetNumber` = '1114' ,`StreetSuffix` = 'Drive' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2525' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The previous homeowners have taken great care of this marvelous two-story home. This gem is nestled in a wonderful neighborhood with friendly neighbors and zoned to excellent schools. As you drive up to this stunning home you\'re greeted with a brick elevation, lovely landscaping, and a beautiful manicured lawn. As you walk into the home you\'re sure to be wowed with the tile flooring throughout the home, roomy living area with a fireplace, spacious kitchen, and lovely formal dining room! Make your way upstairs to find the game room, master bedroom, and the 3 other bedrooms that offer tons of space for you to spruce up as you please! Before you leave don\'t forget to make your way to the roomy backyard that offers a wonderful blue sparkling pool for those hot summer days, it will surely tempt you to take a quick dip!' ,`Acres` = '0.1582' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 27 BLK 9 BAYOU BEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6890' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'BONNETTE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bayou Bend' ,`TaxAmount` = '6969' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072427' WHERE `Matrix_Unique_ID` = '212648369' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:23:42.140' ,`MLSNumber` = '51054684' ,`ListAgentFullName` = 'Christi Finnell' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.040654' ,`Longitude` = '-95.643269' ,`PhotoCount` = '34' ,`PostalCode` = '77429' ,`RoomCount` = '6' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Black Pine' ,`StreetNumber` = '15015' ,`StreetSuffix` = 'Circle' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2954' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning Beazer home still smells new as you walk in the front door! Positioned on a cul-de-sac lot, this beautiful home is walking distance to all the great amenities. Entertain your guests in the oversized great room, open to the kitchen. This home has modern finishes including black cabinets and wood inspired tile flooring in the main living area. Gourmet kitchen with a large island, double ovens and a walk-in pantry. All bedrooms down including a mother-in-law suite with ensuite bathroom. Relax on the cover back patio in the evenings in a large yard big enough for a pool. Award winning Tomball ISD!' ,`Acres` = '0.2244' ,`Area` = '35' ,`BuilderName` = 'Beazer' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 HAYDEN LAKES SEC 7' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9777' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hayden Lakes Sec 7' ,`TaxAmount` = '10108' ,`TaxRate` = '2.8172' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072427' WHERE `Matrix_Unique_ID` = '212662228' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:09:56.890' ,`MLSNumber` = '94171714' ,`ListAgentFullName` = 'Merrily Thompson' ,`ListOfficeName` = 'Fairwater Westmont Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.251390' ,`Longitude` = '-95.572954' ,`PhotoCount` = '49' ,`PostalCode` = '77354' ,`RoomCount` = '13' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Pebble Lake' ,`StreetNumber` = '2426' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3992' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'As you enter this beautiful 5 bed, 4 bath split plan home you are invited to a curved staircase from the foyer along with a formal dining area and study to your right. Upstairs you will find a suite suitable for in-laws with a bedroom, living area and full bath. The spacious kitchen offers double convection ovens, a gas cooktop and breakfast bar. With an open floor plan to living room, you are provided a view to the rear covered porch and beach entry pool featuring a waterfall through large picture windows. Two of the downstairs bedrooms adjoin by a hollywood bath. An informal dining space along with a flex room are nice bonus areas. You can enjoy gardening with the raised boxes just behind the pool and compliment your organic desires w/the small livestock pen as well. The back yard is fully fenced and the mature landscape provides privacy. Take a short walk to the Jerry Nickerson Park to enjoy the private lake and playground. 20 KW gas whole house generator completes the package!' ,`Acres` = '1.476' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'MONTGOMERY TRACE 01, BLOCK 6, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '64295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Trace 01' ,`TaxAmount` = '9122' ,`TaxRate` = '1.8237' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072427' WHERE `Matrix_Unique_ID` = '212729207' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T06:09:29.057' ,`MLSNumber` = '69492864' ,`ListAgentFullName` = 'Mary Keller' ,`ListOfficeName` = 'Origen Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.826571' ,`Longitude` = '-94.816363' ,`PhotoCount` = '25' ,`PostalCode` = '77523' ,`RoomCount` = '1' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Danna' ,`StreetNumber` = '203' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Zoned in BHISD. Lovely 4 bedroom 2.5 bath home, has an upstairs game/family room with 3 upstairs bedrooms and 1 full bathroom. Primary bedroom and primary bathroom is located downstairs. Kitchen has beautiful granite counters, stainless appliances, ample storage and pantry. There is a bonus room currently being used as an office space. Laundry room recently renovated to add extra storage. Fresh paint throughout home! Don\'t miss the chance to call this house your home! Schedule your showing today.' ,`Acres` = '0.232' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 38 LANAI SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10106' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '211' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lanai Sec 02' ,`TaxAmount` = '3850' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072427' WHERE `Matrix_Unique_ID` = '212729647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:01:09.087' ,`MLSNumber` = '46008367' ,`ListAgentFullName` = 'Gina Tran' ,`ListOfficeName` = 'Century 21 ExclusiveProperties' ,`SellingAgentFullName` = 'Emily Mattox' ,`SellingOfficeName` = 'Divine Dreams Real Estate' ,`Latitude` = '29.449764' ,`Longitude` = '-95.434093' ,`PhotoCount` = '47' ,`PostalCode` = '77583' ,`RoomCount` = '13' ,`ListPrice` = '485000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Emerald Pines' ,`StreetNumber` = '2715' ,`StreetSuffix` = 'Lane' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'H&B Deadline: Submit the highest and best offer by 10/5 at 11AM. Entertainer\'s DREAM is what this incredible home has to offer! On a massive 14000 sq ft lot on a CUL-DE-SAC street offers quiet living. IMMACULATE condition, like NEW with elegant exterior. Step in and experience the 12\' soaring ceilings, 8\' doors, wood floors and the exquisite fireplace. The luxury continues into the heart of the home, your kitchen complete with stainless steel apps, granite counters, walk-in and butler’s pantry. The master bedroom features a private bath with a corner tub, double vanities, an extra large shower. There’s MORE! MEDIA room, SUMMER KITCHEN, FULL sprinkler sys, 3-car garage. Added upgrades inc water filtration sys, fully tiled front, back porch and garages, gutters, fully screened back porch. All in a GATED community with amenities galore: basketball, volleyball, tennis courts, playground, waterpark, lap pool. Min to 288 and 6, < 1 hr to Kemah and sunsets at the beach. This can ALL be YOURS!' ,`Acres` = '0.3214' ,`Area` = '5' ,`BuilderName` = 'Terrata Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING LAKES AT IOWA COLONY SEC 20 (A0289 HT&B) BLK 2 LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Lakes At Iowa Colony' ,`TaxAmount` = '15263' ,`TaxRate` = '3.4099' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072428' WHERE `Matrix_Unique_ID` = '212732430' --> 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','212809703','1665072428','212809703','2022-10-06T07:56:59.377','35021516','Keith Rodgers','Realty ONE Group Iconic','','','30.153028','-95.382627','42','77386','4','360000.00','Active','Gable Landing','3606','Lane','Spring','2','0','4','2031','Single-Family','Exquisite Single-Story sitting on a corner lot in the sought-after community, Falls at Imperial Oaks. Brand New whole home generator keeps the lights on during inclement weather! This 3/4 Bedroom-Study | 2 Baths | Oversized 2-Car Garage, offers 2,000+ SF of impeccably maintained living space. The interior features a very functional, open-concept plan, hosting a spacious family room with fireplace, study/bed room located adjacent, and a gorgeous island kitchen that boasts a tasteful granite surface and an abundance of cabinetry space. Built-in gas cooktop, SS appliances, central island offering even more storage. The primary suite is above average in size, dual closet, accompanied by a full bath, including an over-sized shower. The secondary bedrooms share equal size and a full bath between them. Enjoy a beautiful private backyard under an extended patio. Extended size garage features work bench area with mop sink, tankless water heater located in garage. Zoned to Grand Oaks HS.','0.1914','15','Ryland Homes','','Electric Dryer Connections,Washer Connections','','Exclusions,Mud,Other Disclosures,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Spring Northeast','Central Gas,Zoned','1','S504210 - FALLS AT IMPERIAL OAKS 10, BLOCK 2, LOT 16','Corner,Subdivision Lot','8338','Appraisal District','','650','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','BIRNHAM WOODS ELEMENTARY SCHOOL','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Falls At Imperial Oaks 10','7637','3.0687','Public Sewer,Public Water,Water District','2014','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T06:11:17.913' ,`MLSNumber` = '81675732' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'RE/MAX Legends' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.130891' ,`Longitude` = '-95.597612' ,`PhotoCount` = '34' ,`PostalCode` = '77375' ,`RoomCount` = '8' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Morgan' ,`StreetNumber` = '25402' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN READY! FANTASTIC 1 STORY! EXPANSIVE .95 ACRE (per HCAD) CUL-DE-SAC LOT WITH POOL! Loaded with Updates & Upgrades! Beautiful Double Door Foyer! GIGANTIC 40 x 19 Family Room - Wood-Look Tile Flooring, Majestic Fireplace, & Dual Sets of French Doors Leading to Backyard & Pool! Chef\'s Dream Kitchen: Granite Counters, Double Ovens, Stainless Microwave, & Updated Cabinetry! Big Walk-In Pantry! Spacious Dining Area - Wet Bar with Glass-Front Cabinetry! King-Sized Master Suite - Dramatic Tray Ceiling! Updated Bath with Dual Sinks, Jetted Tub/Shower, & Walk-In Closet! Big Secondary Bedrooms - Both with Walk-In Closets! Lovely Updated Guest Bath - Wall of Built-In Cabinetry, Dual Sinks, & Framed Mirrors! Oversized 13 x 10 Utility Room! Detached Garage! Super Private Retreat-Style Backyard: Heated Pool with Extensive Decking, Outdoor Shower, Mature Landscaping, & Storage Building! Recent Roof, Paint, Fence, Pool Pump,++! Easy Access to The Woodlands + Tomball! Super Low Tax Rate! WOW!' ,`Acres` = '0.95' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 2 NORTH WOODS ESTATES' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '41382' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northwood Estates' ,`TaxAmount` = '3143' ,`TaxRate` = '2.0872' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072428' WHERE `Matrix_Unique_ID` = '212824271' --> 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','212977480','1665072428','212977480','2022-10-06T07:43:55.593','33328507','Marita Corkill','eXp Realty, LLC','','','29.486746','-95.166170','33','77573','9','449900.00','Active','Westwood','281','Drive','League City','2','1','3','2504','Single-Family','Immaculate 3-4/2.5/2 in the highly sought neighborhood Westwood/LC! One of Gehan Homes popular open floor plans*bike ride to the new CCISD\'s Campbell Elementary & neighborhood park/pool*Wow your guests as they walk in the door with this beautiful open floor plan, tile wood plank flooring, study with glass French doors*Proceeding on with an open formal dining space and a grand living room w/warm fireplace,*Kitchen open to living room w/ lots of cabinet & counter space*Island is great for school work or entertaining*Breakfast table area off kitchen*Primary retreat with wall of windows & amazing primary bath*Walk in closet, corner tub, walk in shower & his and her vanities* Hurry, this won\'t last long!','0.161','33','Gehan','','','','Sellers Disclosure','1','','','League City','Central Gas','1','WESTWOOD SUB PH 1 (2007) ABST 9, BLOCK 1, LOT 41, ACRES 0.16','Subdivision Lot','7011','Appraisal District','','500','0','','2','','0','','','Gas Cooktop','','Composition','9 - Clear Creek','CAMPBELL ELEMENTARY SCHOOL (CLEAR CREEK)','CLEAR SPRINGS HIGH SCHOOL','CREEKSIDE INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Westwood Sub Ph 1 2007','6710','2.0697','Public Sewer,Public Water','2013','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','212984635','1665072428','212984635','2022-10-06T07:09:05.537','92105862','Lourdes Codina','Keller Williams Realty - Memorial','','','29.827604','-95.730410','37','77449','5','330000.00','Active','Cypress Rain','20731','Drive','Katy','2','0','3','1510','Single-Family','Beautiful 6 year old 3 Bedroom, 2 Bath Home, feels like new! Spacious Backyard and a covered and extended Patio. The Home\'s Facade is beautiful and welcoming. You will love the spacious kitchen with oversized granite Countertop. Don\'t miss this opportunity to own a home in the very desireable Raintree Village!','0.132','25','','','','','Mud,Sellers Disclosure','1','','','Katy - North','Central Gas','1','LT 8 BLK 3 RAINTREE VILLAGE SEC 13','Subdivision Lot','5751','Appraisal District','','436','0','','2','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','30 - Katy','FRANZ ELEMENTARY SCHOOL','MORTON RANCH HIGH SCHOOL','MCDONALD JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Raintree Village, Raintree Vlg','5072','2.5633','Water District','2016','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','212987677','1665072428','212987677','2022-10-06T07:47:09.657','76305169','Holly Smith','Boulevard Realty','','','29.804843','-95.413184','25','77008','8','350000.00','Active','21st','819','Street','Houston','2','0','2','1560','Single-Family','Whether you love biking the trails, dining and a little pub crawling, being within a short sprint to downtown or living the good life in your own private spaces, you\'re home. This gated 3-unit neighborhood is conveniently located and has a private covered outdoor patio area with gas grill. Stainless steel kitchen appliances included. Open floor plan, great natural light, treetop views, wood floors, granite counters, and a fantastic primary walk-in closet. In addition to all the nearby trails, eateries, and pubs, this delightful home is also just around the corner from Wright-Bembry Park and less than 4 blocks from the Heights H-E-B.','0.0482','9','Drake Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Heights/Greater Heights','Central Gas','0','LT 2 BLK 1 VILLA MARIA ELENA AMEND','Patio Lot','2100','Appraisal District','','400','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','SINCLAIR ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (HOUSTON)','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Craftsman','Villa Maria Elena #1','7391','2.3307','Public Sewer,Public Water','2012','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','212997131','1665072428','212997131','2022-10-06T06:13:51.087','84441599','Monica Foster','eXp Realty, LLC','','','29.601400','-95.109616','36','77059','3','250000.00','Active','Dunmoor','16430','Drive','Houston','2','0','3','1136','Single-Family','Incredible single story home with 3 bedrooms, 2 baths & 2 car garage. Located in a quiet neighborhood close to amazing schools, restaurants & parks! Home has been beautifully updated! Large family room with high ceilings, stunning electric fireplace with amazing mantle and hearth. Shelving above fireplace provides wonderful space for showcasing your favorite collectibles or photographs. Amazing kitchen which has been updated with stainless appliances, granite counters and large dining area. Primary bedroom is located at the back of the home & has an en suite bathroom with gorgeous and very large walk in shower. 2 additional spacious bedrooms and secondary bath between them. French doors to the back patio provides a great covered area perfect for outdoor dining, your morning coffee or relaxing on the weekend. Incredible space in the backyard for outdoor fun, the kids to play or tossing a ball for the family dog. Great pride of ownership with this home ... Inside and Out! Hurry to see!','0.1692','7','','','','','Sellers Disclosure','','','1','Clear Lake Area','Central Electric','1','LT 8 BLK 34 MIDDLEBROOK SEC 1','Subdivision Lot','7371','Appraisal District','','445','0','','2','','0','','','','','Composition','9 - Clear Creek','ARMAND BAYOU ELEMENTARY SCHOOL','CLEAR LAKE HIGH SCHOOL','SPACE CENTER INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Ranch','Middlebrook Sec 01','5155','2.5769','Public Sewer,Public Water','1973','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T06:30:51.253' ,`MLSNumber` = '31583364' ,`ListAgentFullName` = 'Margaret Beach' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Erica Wetherell' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.767076' ,`Longitude` = '-95.704936' ,`PhotoCount` = '25' ,`PostalCode` = '77094' ,`RoomCount` = '12' ,`ListPrice` = '575000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Whispering Breeze' ,`StreetNumber` = '19403' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3615' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely home in Green Trails with no backyard neighbors. Home offers 4 bedrooms, 3.5 bathrooms, study and 3 car garage. Nicely updated with beautiful flooring throughout, updated chef\'s kitchen with SS appliances, 7.5 ft island with excellent storage. Neutral paint selection and timeless Plantation shutters. Owners retreat on the first floor is spacious and overlooks a lovely landscaped backyard. Ensuite bath features a lovely walk-in shower, double vanities and 2 walk-in closets. Study and formal dining room complete the first floor. Main staircase offer 2 story foyer ushers you to a secondary bedroom and private bath along with an extra flex room with many options. Back staircase escorts you to the game room along with 2 secondary bedrooms and Jack & Jill bath. Beautiful mature trees landscape the private backyard that is gated to green space and walking trail. Three car garage is a bonus you won\'t want to miss.' ,`Acres` = '0.2418' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 5 GREEN TRAILS PARK SEC 7 AMEND' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '10531' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1258' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'NOTTINGHAM COUNTRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MEMORIAL PARKWAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Green Trails Park Sec 07 Amd' ,`TaxAmount` = '8681' ,`TaxRate` = '2.2083' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072428' WHERE `Matrix_Unique_ID` = '213008398' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:39:49.883' ,`MLSNumber` = '40240626' ,`ListAgentFullName` = 'Elizabeth Cencini' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.571924' ,`Longitude` = '-95.311986' ,`PhotoCount` = '50' ,`PostalCode` = '77581' ,`RoomCount` = '5' ,`ListPrice` = '384000.00' ,`Status` = 'Active' ,`StreetName` = 'Orchard Trail' ,`StreetNumber` = '6001' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2357' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy this gorgeous one story four bedroom home located on a corner lot and conveniently across from your community pool and a recreational park. This home is also in a great location in the heart of Pearland.\r\nThis home features many additions that include outdoor additions in patio, an outdoor kitchen with granite countertops and bar, stainless steel appliances, covered pergola with flooring paved deck, driveway side additions to widen the driveway, storage shed installed, new light fixtures and new flooring in some rooms including all new carpet of which add up to 29k in additions! A/C recently installed and home has not had any flooding in any major weather conditions. The oversized island in the kitchen can accommodate all your guest in the family room and has a gracious amount of space! Zoned to Pearland ISD. Close to broadway and shopping centers. A must see home!' ,`Acres` = '0.1949' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VILLAGE GROVE SEC 2 (A0544 HT&B) (PEARLAND) BLK 2 LOT 10' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8490' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '515' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'LAWHON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH WEST' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Grove' ,`TaxAmount` = '8614' ,`TaxRate` = '2.8451' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072428' WHERE `Matrix_Unique_ID` = '213008827' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:35:44.407' ,`MLSNumber` = '60273654' ,`ListAgentFullName` = 'Juliana Swisher' ,`ListOfficeName` = 'South Haus Living, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.477969' ,`Longitude` = '-95.518120' ,`PhotoCount` = '28' ,`PostalCode` = '77459' ,`RoomCount` = '7' ,`ListPrice` = '720000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress' ,`StreetNumber` = '10123' ,`StreetSuffix` = 'Path' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous home features a spacious floor plan, elegant finishes and architectural details throughout. Walking in you\'re greeted with a beautiful double-height grand entry. Past the foyer, you\'ll find a private study with french doors and separate dining room. The stunning living area boasts soaring ceiling heights and windows, casting in great natural light. Off the living area is the kitchen with upgraded cabinetry, an island perfect for entertaining, along with a breakfast area. The large 1st-floor primary suite boasts beautiful architectural details in the molding and tray ceiling. An additional tucked away 1st-floor bedroom suite can be great for guests or additional bedroom. The 2nd floor is a fabulous example of great layout by design. Two bedrooms with a Hollywood-style bathroom, a great game room space, a dedicated media room, and an additional bedroom and full bath. The backyard rounds off this wonderful home, with a large yard, covered patio, and an open extended patio.' ,`Acres` = '0.1973' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA PLANTATION SEC 10, BLOCK 1, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8595' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Plantation Sec 10' ,`TaxAmount` = '13354' ,`TaxRate` = '3.1629' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072428' WHERE `Matrix_Unique_ID` = '213010398' --> 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','213032740','1665072429','213032740','2022-10-06T07:04:08.970','85052167','Matthew Lam','eXp Realty, LLC','','','30.135645','-95.516614','19','77389','9','450000.00','Active','Auburn Bend','25318','Drive','Spring','3','1','4','2726','Single-Family','Charming one and half story in the sought after Auburn Lakes community! This 4 bedroom, 3.5 bathroom home showcases an open concept living, formal dining, breakfast room, and a cozy warm living room that opens right into the kitchen. A chef\'s dream kitchen is complete with a large quartz island for entertaining, stainless steel appliances, updated LED recessed lights, and stylish pendants that brings the room together. The generous sized primary bedroom suite features a huge walk in closet and fresh, luxurious bathroom! Fabulous mudroom/utility room is outfitted with built-in backpack rack. Beautiful back patio overlooks large, fully fenced backyard that was replaced in 2021! Don’t miss this fantastic opportunity!','0.1722','14','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Spring/Klein','Central Gas','1','LT 5 BLK 2 AUBURN LAKES PINES SEC 5','Subdivision Lot','7500','Appraisal District','','690','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','32 - Klein','FRENCH ELEMENTARY SCHOOL (KLEIN)','KLEIN OAK HIGH SCHOOL','HOFIUS INTERMEDIATE SCHOOL','Leave Business Card,No Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','1.5','Traditional','Auburn Lakes Pines Sec 5','9588','2.914','Water District','2013','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T06:53:16.427' ,`MLSNumber` = '12920852' ,`ListAgentFullName` = 'Jaclyn Thayn' ,`ListOfficeName` = 'Texas Living Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.754252' ,`Longitude` = '-95.748284' ,`PhotoCount` = '29' ,`PostalCode` = '77450' ,`RoomCount` = '9' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashford' ,`StreetNumber` = '21734' ,`StreetSuffix` = 'Grove' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3230' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Introducing 21734 Ashford Grove! A 4 bedroom, 3 bath dream home located on a beautiful cul-se-sac with mature trees and gorgeous neighborhood amenities. This home features new vinyl water proof flooring, fresh paint through out, new carpet, bright and open kitchen with new granite and tile backsplash, and a brand new AC unit. Offering an open layout with plenty of large windows and natural light, dining and formal living room, family room and game room. The spacious back yard allows for so many possibilities! Zoned to A-rated, award winning Katy ISD, this home will go fast. Contact listing agent for neighborhood amenities.' ,`Acres` = '0.2165' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 1 OAK PARK TRAILS SEC 10' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9429' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'EXLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Park Trails Sec 10' ,`TaxAmount` = '7087' ,`TaxRate` = '2.4133' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072429' WHERE `Matrix_Unique_ID` = '213034713' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:51:09.707' ,`MLSNumber` = '51518813' ,`ListAgentFullName` = 'Jayme Foster' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = 'John Correa' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.039632' ,`Longitude` = '-94.885982' ,`PhotoCount` = '36' ,`PostalCode` = '77535' ,`RoomCount` = '9' ,`ListPrice` = '435000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Young' ,`StreetNumber` = '201' ,`StreetSuffix` = 'Street' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3164' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS HOME SITUATED ON A CORNER, 1/2 ACRE LOT. OVERSIZED SIDE DRIVEWAY TO ACCOMODATE MULTIPLE TYPE VEHICLES. ADDITIONAL DRIVEWAY ON THE OTHER SIDE, GREAT FOR RV PARKING. HUGE GATED, COVERED PATIO WITH A VIEW OF THE BEAUTIFUL POOL AND EXTENSIVE BACKYARD AREAS. SO MUCH ROOM FOR ENTERTAINING, FAMILY GATHERINGS AND PEACEFUL EVENINGS. INSIDE BOASTS A LARGE MUD/LAUNDRY AREA, LARGE KITCHEN AND BREAKFAST AREAS, ENORMOUS DINING AREA, FAMILY ROOM, DEN WITH FIREPLACE AND BUILT-INS, STUDY/OFFICE, LARGE MASTER WITH ADDITIONAL BUILT-INS IN THE BATHROOM AND GRAND CLOSET AREA, AND TWO ADDITIONAL BEDROOMS. THIS BEAUTY IS EVERYTHING YOU COULD WANT AND MORE. A MUST SEE!' ,`Acres` = '0.4993' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'DAYTON, BLOCK 2, LOT 2, TRACT 2 3 13, ACRES .4993' ,`LotDesciption` = 'Corner' ,`LotSize` = '21750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dayton' ,`TaxAmount` = '9192' ,`TaxRate` = '2.4832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072429' WHERE `Matrix_Unique_ID` = '213091873' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T06:49:34.257' ,`MLSNumber` = '67113746' ,`ListAgentFullName` = 'Sherrin Quire' ,`ListOfficeName` = 'Gulf Coast, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.471606' ,`Longitude` = '-95.085749' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '4' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Caine Hill' ,`StreetNumber` = '1415' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3346' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This David Powers home has four bedrooms and one large office, as well as a two car garage and two quaint covered patios in the back. Enjoy a full kitchen with dishwasher, stovetop, oven, two full sized fridges, and very large pantry. Large formal dining room. Washer/dryer in laundry room will remain. Amazing floor plan with tons of space! Custom built in Buffet and Wine bar, Gourmet kitchen, huge master suite with sitting area and spa-like master bathroom! Great guest room with private bath, additional bedrooms are very spacious with Jack n Jill baths with private vanities! Foyer truly has a grand entry with elegance everywhere you look! Peaceful Cul-de-sac lot! The extra one car garage has a built in lifestyle screen(2018) to pull down to escape the mosquitos! No back neighbors! New roof 2022. 14 foot ceilings and 8 ft doors! Koehler generator that automatically runs entire house! Electric oven 2020, 5 ton gas furnace 2019.' ,`Acres` = '0.2035' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VICTORY LAKES SEC 1 (2001), ABST 3 S F AUSTIN SUR, BLOCK 2,' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8863' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '779' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'RALPH PARR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Victory Lakes Sec 1 2001' ,`TaxAmount` = '7940' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072429' WHERE `Matrix_Unique_ID` = '213102130' --> 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','213208175','1665072429','213208175','2022-10-06T07:44:43.487','75392492','Milan Aron','MOD Realty, LLC','','','30.292088','-95.488493','40','77304','7','343000.00','Active','Clonmore','1123','Court','Conroe','2','0','3','2002','Single-Family','Don\'t miss this incredible opportunity to live in the desirable Canyon Creek neighborhood of Conroe, TX. This gorgeous home is beautifully situated in a serene setting. It was built in 2019 and has only had one owner. The home features high ceilings, custom cabinets, granite countertops, stainless steel appliances, and more. The backyard boasts a lovely covered patio to host outdoor gatherings as well as an extended yard, perfect to install a pool or allow pets to run free. There are 3 bedrooms, 2 full baths, and an extra room for an office, home gym, or flex space.','0.2595','19','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','','','Conroe Southwest','Central Gas','1','S336690 - CAYDEN CREEK 04 PARTIAL REPLAT NO 1, BLOCK 1, LOT','Subdivision Lot','11304','Appraisal District','','585','0','','2','Gas Oven','0','','','Electric Cooktop','','Composition','11 - Conroe','RICE ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment','Appraisal District','1','Traditional','Cayden Creek 04 Pt Rep 1','6048','2.8863','Public Sewer,Public Water','2019','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','213208315','1665072429','213208315','2022-10-06T07:51:03.280','34278550','Brenda Hebert','Keller Williams Realty - Clear Lake/ NASA','','','29.469143','-95.115400','50','77573','4','465000.00','Active','Amado','2001','Lane','League City','4','0','4','2831','Single-Family','Plan #253 offers 4 bedrooms and 3 full bathrooms in the home, MASSIVE Bonus Room with Glass French Doors, in addition to a Formal Dining Room with dual access from different areas of the home (french doors off of the front entry and second door off of the kitchen). This plan offers a second primary suite perfect for MIL or Guests as it has its own full/private bathroom. This split floor plan has the primary suite in the back of the home and two additional bedrooms with a 3rd large bathroom at the front of the home. The kitchen is large with 42\" cherry cabinets, granite countertops, a large island, and it\'s open to the family room and breakfast area. There\'s a walk in pantry and a generously sized laundry room right off the kitchen. The garage is a 2.5 car in size with a full bathroom and a 2.5 car porte-cache provides covered parking; double wide driveway; quiet corner lot. New luxury vinyl floors throughout; new paint throughout. See Attachments for full list of updates by builder','0.2311','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','League City','Central Gas','1','SEDONA SEC 5 (2017) ABST 3, BLOCK 8, LOT 54, ACRES 0.23','Cleared,Corner,Subdivision Lot','10067','Appraisal District','','300','0','','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','9 - Clear Creek','BAUERSCHLAG ELEMENTARY SCHOOL','CLEAR SPRINGS HIGH SCHOOL','VICTORYLAKES INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Sedona Sec 5','6067','2.004626','Public Sewer,Public Water','2017','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T06:39:59.260' ,`MLSNumber` = '70897130' ,`ListAgentFullName` = 'Wayne Au' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.559159' ,`Longitude` = '-95.530400' ,`PhotoCount` = '27' ,`PostalCode` = '77459' ,`RoomCount` = '3' ,`ListPrice` = '308800.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeshore Forest' ,`StreetNumber` = '4223' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1902' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice neighbor hood, Bright house, High ceiling, new exterior paint, new AC, new grantie kitchen counter top, new laminate water proof in Dining and family room. No house on the back.' ,`Acres` = '0.1542' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKESHORE FOREST AT LAKE OLYMPIA SEC 2, BLOCK 2, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6718' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1081' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PALMER ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Lakeshore Forest At Lake Olympia Sec 2' ,`TaxAmount` = '5776' ,`TaxRate` = '2.79' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072429' WHERE `Matrix_Unique_ID` = '213229883' --> 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','213247123','1665072429','213247123','2022-10-06T07:48:24.270','10882170','Amanda Seidel','JLA Realty','','','29.855100','-94.814669','32','77523','3','367500.00','Active','Oaks Grande','107','Road','Mont Belvieu','2','0','3','2037','Single-Family','Custom built home in small community of homes sits on a little over 1/2 an acre of manicured land. The floorplan is open concept with the kitchen, dining, and living room being the heart of the home. 3 nice size bedrooms, 2 full bathrooms (master has separate tub/shower), and a study complete this home. Kitchen & bathroom countertops have been updated (2022). Walk out the back door & you\'ll find a 16x24 workshop complete with electricity so you can work on those big projects or use it as a storage shed if that fits your needs better. The back patio is covered so you can enjoy evenings or early mornings outside. Plenty of space here to do whatever your heart desires! This home also falls in the sought after Barber\'s Hill ISD','0.53','53','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Chambers County West','Central Electric','0','LT 1 OAKS GRANDE SECTION 1','Corner,Subdivision Lot','23087','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','6 - Barbers Hill','BARBERS HILL NORTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL NORTH MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Ranch,Traditional','Oaks Grande','4660','1.7058','Public Water,Septic Tank','2002','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','213262997','1665072429','213262997','2022-10-06T07:03:42.043','76844086','Kim Tyler','Greystone Realty, LLC','','','29.682680','-95.699104','0','77407','9','337650.00','Active','Carmel Grove','8902','Lane','Richmond','2','1','3','2251','Single-Family','LOCATION, LOCATION, LOCATION! This Beautiful home offers easy access to shopping centers, as well as the big Amazon warehouse!! It is located on a quiet culde-circle with lots of backyard space! The interior has a very open floor plan with an upstairs game room/flex room for family recreational space! The niches, openness, and built-in shelving gives the home so much character! The home is also pre-wired for a surround sound system and glass break sensors on some windows!! This community has an outdoor pool and other amenities for family enjoyment!','0.2027','37','','','','','Mud,Sellers Disclosure','1','','','Mission Bend Area','Central Electric','1','MISSION SIERRA SEC 5, BLOCK 3, LOT 33','Cul-De-Sac','8830','Appraisal District','','770','0','','2','Gas Oven','0','','','Gas Range','','Composition','19 - Fort Bend','PATTERSON ELEMENTARY SCHOOL (FORT BEND)','TRAVIS HIGH SCHOOL (FORT BEND)','BOWIE MIDDLE SCHOOL (FORT BEND)','Appointment Required','Appraisal District','1.5','Traditional','Mission Sierra Sec 5','5771','2.4429','Water District','2010','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','213263289','1665072429','213263289','2022-10-06T06:31:42.937','56738443','Irisnexy Regueira','Lugary, LLC','','','30.039868','-95.392320','20','77373','3','295000.00','Active','Lemon Grove','22719','Drive','Spring','2','0','3','1764','Single-Family','Your search is over! Welcome 22719 Lemon Grove Dr. Is located in the well - established Timber Lane Subdivision. This incredible 1 story home has everything that you were looking. Completely remodeled offers a spacious / open floor plan with 3 bedroom/ 2 baths / 2 car garage and a big driveway with enough space for more cars. It was remodeled taking care every detail making this house the perfect option for you and your family, soft close drawers and door, brand new stainless appliances, countertop electric stove, wall oven, custom kitchen island, island range hood, quartz countertop, ceramic tiles. in ground pool and spa with heater, brand new pool equipment, whole house smart lighting system. Make your appointment today, at this price it will not last. No flooding here','','12','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Spring East','Central Electric','1','LT 7 BLK 36 TIMBER LANE SEC 5','Other','8614','Survey','','','0','','4','','1','In Ground','','','','Composition','48 - Spring','PEARL M HIRSCH ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','TWIN CREEKS MIDDLE SCHOOL','Supra Keybox,Vacant/Unoccupied','Seller','1','Traditional','Timber Lane Sec 05','4717','3.0268','Public Sewer','1975','Seller'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:59:29.587' ,`MLSNumber` = '18267544' ,`ListAgentFullName` = 'Andrew Githens' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.217203' ,`Longitude` = '-95.412166' ,`PhotoCount` = '23' ,`PostalCode` = '77385' ,`RoomCount` = '7' ,`ListPrice` = '280500.00' ,`Status` = 'Active' ,`StreetName` = 'Woodloch' ,`StreetNumber` = '2656' ,`StreetSuffix` = 'Street' ,`City` = 'Woodloch' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2306' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained hard to come by ranch style located 3 miles to I-45 & the medical center and is situated on a 1/3 acre lot with huge trees. The large two-car enclosed garage provides extra parking with its double wide driveway. Exterior recently painted & Interior upgraded in 2019. 5-ton A/C unit replaced in 2019. Wood like flooring throughout . The foyer offers a built-in nook. The spacious living area with a large brick wood burning fireplace and canned LED lights flows into the kitchen with a pass-through opening/ potential bar and the dining room. The kitchen boasts custom soft close cabinets, SS appliances & a walk-in pantry. A hard-wired security system with cameras and owned outright. Large utility room with access to patio & garage provides additional cabinet storage & space for a stand-up freezer/fridge. Private patio 25\' W x 17\'D looks out to city-maintained lots. Patio furniture stays with the sale of the home.' ,`Acres` = '0.3375' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WHISPERING OAKS 01, BLOCK 2, LOT 41' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Whispering Oaks 01' ,`TaxAmount` = '1833' ,`TaxRate` = '2.1849' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072430' WHERE `Matrix_Unique_ID` = '213264101' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:28:51.677' ,`MLSNumber` = '93443799' ,`ListAgentFullName` = 'Kevin King' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.865551' ,`Longitude` = '-94.854824' ,`PhotoCount` = '0' ,`PostalCode` = '77523' ,`RoomCount` = '8' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'River Run' ,`StreetNumber` = '12219' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1925' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You won\'t want to miss this charming 2 story home with great curb appeal. An Inviting front porch welcomes you to your quaint new home. Once inside you will see why the current owners will miss this home. Downstairs is a lovely bright and airy living room with wood floors and a fireplace, dining area, breakfast bar, kitchen, utility and 1/2 bath. Up you will find 3 bedrooms, 2 bathrooms and a nice game room or 4th bedroom. All of this and more is located in the Fishers Landing Subdivision and City limits of Mont Belvieu.' ,`Acres` = '0.379' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 241 FISHERS LANDING III' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16509' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fishers Landing Sec 03' ,`TaxAmount` = '4401' ,`TaxRate` = '2.1487' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072430' WHERE `Matrix_Unique_ID` = '213271552' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:59:07.640' ,`MLSNumber` = '58610872' ,`ListAgentFullName` = 'Cristal Torres' ,`ListOfficeName` = 'Exceed Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.863644' ,`Longitude` = '-94.854900' ,`PhotoCount` = '38' ,`PostalCode` = '77523' ,`RoomCount` = '8' ,`ListPrice` = '359999.00' ,`Status` = 'Active' ,`StreetName` = 'River Run' ,`StreetNumber` = '12119' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1972' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This magnificent home has been kept in tip top shape, uniquely designed with a lot to offer home owners. From an open concept layout and fresh paint this 3 bedroom home is a must see. Spacious driveway with detached garage and easy access backyard with no back neighbors! Never flooded, no HOA and did I mention Barbers Hill School District? Schedule your private tour today.' ,`Acres` = '0.36' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 274 FISHERS LANDING S/D SECTION 4' ,`LotDesciption` = 'Other' ,`LotSize` = '15682' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fishers Landing Sub' ,`TaxAmount` = '5725' ,`TaxRate` = '2.1487' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1665072430' WHERE `Matrix_Unique_ID` = '213279634' --> 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','213286660','1665072430','213286660','2022-10-06T07:28:43.923','27702411','Yerlin Mendez','Insearch Properties LLC','','','29.643419','-95.140983','29','77505','8','279900.00','Active','Fairbourne','6411','Drive','Pasadena','2','0','3','1441','Single-Family','This completely updated 3/2/2, is nestled in the very sought out Village Grove neighborhood. Zoned to all DPISD schools, you are only 2 blocks away from Fairmont Elementary. New gray tile has been added through out entire home, only bedrooms have new carpet. Open living room with over sized fireplace. Kitchen was recently updated with new cabinets & counter tops. New appliances, new paint through out the entire home including the garage. Updated showers in both bathrooms boasting new tiles and shower fixtures. The rest of the home consists of all new light fixtures, recessed lighting & fans inside & outside of the home! Fresh exterior & interior paint was just done, only a couple of weeks old! All new baseboards through out home. New Gutters (2021),New HVAC (2021) & new air duct system(2021). Schedule a showing today!','0.161','6','','','Gas Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Pasadena','Central Gas','1','LT 25 BLK 7 VILLAGE GROVE SEC 1','Subdivision Lot','7015','Appraisal District','','280','0','','2','Gas Oven','0','','','Gas Range','','Composition','16 - Deer Park','FAIRMONT ELEMENTARY SCHOOL','DEER PARK HIGH SCHOOL','FAIRMONT JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment','Appraisal District','1','Traditional','Village Grove Sec 01','5816','2.8798','Public Sewer,Public Water','1983','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:17:15.800' ,`MLSNumber` = '5674220' ,`ListAgentFullName` = 'Jerry Flowers' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.545605' ,`Longitude` = '-95.665398' ,`PhotoCount` = '30' ,`PostalCode` = '77479' ,`RoomCount` = '3' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Cross Valley' ,`StreetNumber` = '1410' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2314' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Charming and STUNNING One Story home offers 3 bedrooms, 2 baths, Formal Dining AND Private Study. Kitchen is Open to the Family Room with Tons of Cooking Space and cabinets! Kitchen is G-O-R-G-E-O-U-S.... Spacious Primary Bedroom Features Tall Windows which offer lots of light into the home, Wood & Tile Flooring throughout! Spacious Primary Bath - its so Beautiful and Functional. Closed in patio ideal for entertaining, relaxing and reading a book! SPRINKLER SYSTEM reaches ALL vegetation. Paradise awaits you! Newer A/C, 3 year old roof. Never Flooded per Seller! Call to schedule your private viewing today! Zoned to all \'A\' Rated Lamar Consolidated Schools. 3 Neighborhood Pools, Clubhouse & Golf Course.' ,`Acres` = '0.1974' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD BROOKS MILL SEC 1, BLOCK 4, LOT 4' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '8597' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '910' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greatwood Brooks Mill' ,`TaxAmount` = '6232' ,`TaxRate` = '2.3013' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072430' WHERE `Matrix_Unique_ID` = '213303705' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:41:11.390' ,`MLSNumber` = '293583' ,`ListAgentFullName` = 'Jeanne Weaver' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.693902' ,`Longitude` = '-95.532980' ,`PhotoCount` = '20' ,`PostalCode` = '77036' ,`RoomCount` = '6' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Concho' ,`StreetNumber` = '8403' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1939' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sharpstown classic with a pool for those long Texas summers. This wonderful home has a large family room with wood burning fireplace, 3 bedrooms 2 baths. Breezeway enclosed to make extra room that would be a great playroom, workout room, office. Primary suite is sweet. The spa like bath has been totally redone with oversize shower, beautiful sink area. Primary also has good size walk in closet with shelving. Designer lighting is so fun! Utility room has closet and room for an extra fridge/freezer. 2 car detached garage with extra side yard for RV parking, play area. Automatic sprinkler system in front. Convenient location - easy access to Galleria, Downtown, sugar Land, China Town, hospital, worship, schools. Close to 59 & beltway 8. Room sizes are approximate, buyer to verify. No survey available, buyer to purchase new.\r\n***PROFESSIONAL PHOTOS COMING SOON***' ,`Acres` = '0.2147' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 & TR 11 BLK 51 SHARPSTOWN COUNTRY CLUB TERRACE SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9351' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '270' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'NEFF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR GROVE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharpstown Country Club Terrac' ,`TaxAmount` = '5185' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072430' WHERE `Matrix_Unique_ID` = '213323913' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:26:41.377' ,`MLSNumber` = '16878808' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.012357' ,`Longitude` = '-95.311739' ,`PhotoCount` = '6' ,`PostalCode` = '77338' ,`RoomCount` = '9' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Mustang Corral' ,`StreetNumber` = '7414' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 4 bedroom 2.5 bathroom home! This home offers neutral paint colors, a large kitchen that overlooks the family room, and the primary bedroom is on the main level. Enjoy entertaining friends and family by the fireplace for the holidays, or on the covered back patio for a barbecue in the Summer!' ,`Acres` = '0.1136' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 2 SADDLE RIDGE SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '4950' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Saddle Ridge' ,`TaxAmount` = '6454' ,`TaxRate` = '2.7734' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665072430' WHERE `Matrix_Unique_ID` = '213326200' --> 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','213334290','1665072431','213334290','2022-10-06T07:33:31.607','13164856','Rafael Mata','CB&A, Realtors-Katy','','','29.876407','-95.425316','38','77088','7','320000.00','Active','Reverend B J Lewis','973','Drive','Houston','2','1','3','1943','Single-Family','Welcome to this beautiful 2022 new build two story home! This 3 bedroom 2.5 baths home has so much to offer. From Granite tops, tile flooring on the 1st floor, spacious secondary rooms, enclosed front/backyard, and direct access to the second floor balcony from the primary you\'ll want to come in person to see. Minutes away from I-45 & 610 you can easily find yourself in downtown or galleria area within minutes. Seller is also contributing $ to buy down buyer\'s interest rate. Schedule your private showing today! you won\'t want to miss it!','0.1653','11','Builder','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Northwest Houston','Central Electric,Central Gas','0','LT 96 BLK 7 LINCOLN CITY SEC 5','Other','3600','Appraisal District','','','1','Never Lived In','2','Convection Oven','0','','','Gas Range','','Composition','27 - Houston','OSBORNE ELEMENTARY SCHOOL','WASHINGTON HIGH SCHOOL','WILLIAMS MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Builder','2','Traditional','Lincoln City Sec 05','881','2.3307','Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:24:47.413' ,`MLSNumber` = '85947112' ,`ListAgentFullName` = 'Nancy Macias-Morales' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841606' ,`Longitude` = '-95.783113' ,`PhotoCount` = '34' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '424900.00' ,`Status` = 'Active' ,`StreetName` = 'Mantova River' ,`StreetNumber` = '23511' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2710' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'EXQUISITE describes this immaculate home nestled in the exclusive community of Ventana Lakes,and zoned to the award-winning Katy School District.Unique as it offers the best, oversized lot.The amazing island kitchen offers crisp white 42\"cabinetry, granite counters,breakfast bar seating,Frigidaire Stainless Steel appliances, glistening tile backsplash,and plentiful storage.The floorplan is very open & interconnected with sought-after high ceilings. Large,yet private owners retreat with executive en suite bath with a huge walk-in closet.3 great secondary bedrooms with 1 en suite,perfect for guests.Enjoy some time outdoors with a wonderful, tall covered patio.The backyard space is large enough for a pool, garden, swingset, the possibilities are endless.Plus, the storage shed will stay.Ventana Lakes residents enjoy easy access to the community clubhouse,resort-style pool, scenic lakes,walking trails,water park and easy access to Hwys.This home is simply PERFECT! 3D & Video tour available.' ,`Acres` = '0.2355' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 3 Ventana Lakes Sec 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10257' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ventana Lakes' ,`TaxAmount` = '9339' ,`TaxRate` = '3.2768' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665072431' WHERE `Matrix_Unique_ID` = '213334843' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T07:16:02.890' ,`MLSNumber` = '14721233' ,`ListAgentFullName` = 'Brianna Tieperman' ,`ListOfficeName` = 'Keller Williams Coastal Bend' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.029182' ,`Longitude` = '-97.076295' ,`PhotoCount` = '31' ,`PostalCode` = '78382' ,`RoomCount` = '6' ,`ListPrice` = '389900.00' ,`Status` = 'Active' ,`StreetName` = 'Redwood Ave' ,`StreetNumber` = '634' ,`StreetSuffix` = 'Avenue' ,`City` = 'Rockport' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction is ready for you to come home to her! This elegant three bedroom, two and a half bath hits every possible checkmark you’d like to see in a home. Enter through your gorgeous eight ft door to an entryway featuring a 12 to 13 ft drop ceiling. Each bedroom features 9 to 10 ft drop ceilings. Six ft windows throughout the home makes for beautiful natural light wherever you go. Your custom kitchen features under Cabinet Lighting, all appliances and tons more. Beautiful master bedroom with a walk in shower, jacuzzi tub and built in shelves through closet. Control your built in security system, speakers or TVs from the Smart Hub located in the laundry room. Spend evenings on your covered back patio grilling and watching the big game. Home will be fully fenced and sod will be laid in the front and back yard. The list of upgrades, add ons and custom features goes beyond what we have room for. Book your showing today!' ,`Acres` = '0.4477' ,`Area` = '85' ,`BuilderName` = 'JP Assets LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'OAK TERRACE, LOT 209' ,`LotDesciption` = 'Other' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '310 - Aransas County' ,`SchoolElementary` = 'LIVE OAK 1-3 LEARNING CENTER' ,`SchoolHigh` = 'ROCKPORT-FULTON HIGH SCHOOL' ,`SchoolMiddle` = 'ROCKPORT-FULTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Terrace' ,`TaxAmount` = '5881' ,`TaxRate` = '1.7623' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665072431' WHERE `Matrix_Unique_ID` = '213339399' --> 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','213343900','1665072431','213343900','2022-10-06T07:35:46.310','12405562','Olga Lozano','Realty Associates','','','29.792413','-94.949210','49','77521','8','1399000.00','Active','Archer','1321','Road','Baytown','4','1','4','4780','Single-Family','Stately custom built home set on 7.91 acres offers plenty of living space with country sized backyard! Upon entry, you\'re greeted with a wall of windows that flood the home with natural light & beautiful views of your lush backyard! Home offers 4 bedrooms, primary wing located downstairs, and 3 bedrooms upstairs with a flex space that could also work as a fifth bedroom. All bedrooms offer ensuite bathrooms along with walk-in closets. Chef’s kitchen overlooks the family room and offers the perfect backdrop for all your family gatherings. Home offers great flow for your entertaining needs. Two balconies, a covered patio area, and a porte-cochere are just a few of the features this home has to offer. The backyard has tons of potential and is only limited to your imagination. A pond can also be found in the middle of the property! Home offers a three-car garage and ample parking space for your guests. Schedule your appointment today!','7.91','2','','','Gas Dryer Connections,Washer Connections','','No Disclosures,Sellers Disclosure','0','','','Baytown/Harris County','Central Gas','0','LT 1 BLK 1 LEYVAS','Cleared,Wooded','344559','Appraisal District','','','0','','3','Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','23 - Goose Creek Consolidated','STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)','STERLING HIGH SCHOOL (GOOSE CREEK)','GENTRY JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','LEYVAS','24636','2.285','Septic Tank,Well','2006','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','213365672','1665072431','213365672','2022-10-06T06:03:15.737','73136292','Jimmy Franklin','eXp Realty, LLC','','','29.532008','-95.726465','28','77469','9','395000.00','Active','Snyder Farm','8730','Lane','Richmond','3','1','4','2491','Single-Family','Welcome to this charming two story home situated on a large corner lot in Bonbrook Plantation. Features include a stone & brick facade with covered front porch, two story entry, private home office, open living spaces, 4 bedrooms, 3.5 baths, a gameroom & oversized backyard! The kitchen boasts a large island with breakfast bar, stainless steel appliances, 42\" cabinetry, granite countertops & recessed lighting. The primary suite, located on the 1st floor, offers a soaking tub, separate shower & walk-in closet. Upstairs you will find the gameroom & guest bedrooms. Neutral colors throughout. Home is within walking/biking distance to the community pool, clubhouse, playground & lakes. Conveniently located just minutes from 59, shopping, restaurants & all of the Lamar Consolidated schools the home is zoned to. Don\'t miss this one!','0.2173','30','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Fort Bend South/Richmond','Central Gas','1','BONBROOK PLANTATION NORTH SEC 14, BLOCK 1, LOT 1','Corner,Subdivision Lot','9465','Appraisal District','','700','0','','2','Convection Oven,Gas Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','CARTER ELEMENTARY SCHOOL','GEORGE RANCH HIGH SCHOOL','RYON/READING JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Bonbrook Plantation North','7126','2.6948','Water District','2017','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','213366181','1665072431','213366181','2022-10-06T07:55:02.067','62199150','Melanie Montgomery','Coldwell Banker Realty','','','30.453470','-95.743548','38','77356','5','345000.00','Active','FM 1097','28102','','Montgomery','2','0','3','1568','Single-Family','Charming three bedroom, two bath home perfectly situated on partially wooded acre of property located 15 minutes from Lake Conroe. Whether you enjoy relaxing on your porch taking in the beautiful country scenery or prefer playing on the lake on the weekends, this amazing property can accommodate whatever lifestyle you crave. This outstanding property is located in the highly sought after Montgomery ISD. This property also has the option to be sold with 2 acres and 3 structures total. If interested in this option, please reach out for pricing. It won\'t last long, so come take a look today before it\'s gone.','1','39','','','','','Sellers Disclosure','1','','','Montgomery County Northwest','Central Electric','0','A0604 - WOOD JOHN, TRACT 3-H, ACRES 1','Other','','','','','0','','2','','0','','','Electric Range','','Composition','37 - Montgomery','LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Richards','2482','1.8242','Aerobic','2017','Appraisal District'); --> New record created successfully