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-12T06:49:14.090' ,`MLSNumber` = '14835349' ,`ListAgentFullName` = 'Dee Dee Guggenheim Howes' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745106' ,`Longitude` = '-95.404481' ,`PhotoCount` = '32' ,`PostalCode` = '77019' ,`RoomCount` = '12' ,`ListPrice` = '1990000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodhead' ,`StreetNumber` = '2315' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Ava Custom Homes, this stunning new-construction residence offers sleek contemporary design and gorgeous outdoor space in coveted River Oaks area. Soaring ceilings, oversized steel windows, lime-washed brick and engineered white oak floors add a bright, modern ambiance throughout. From the foyer, French doors open to a spacious study. Ahead, open-plan living spaces simply beg to entertain with a formal dining room, walk-up bar, wine room, great room and folding glass doors that open to the massive, covered patio. Above, the exquisite palatial owner suite boasts a gorgeous spa bath and dual boutique style walk-in closets. Three more secondary suites surround a massive game room. Utility room, elevator-ready layout, three-car tandem garage. Spectacular location close to galleries, shopping, dining and parks. Schedule your tour today!' ,`Acres` = '0.1354' ,`Area` = '16' ,`BuilderName` = 'Ava Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'River Oaks Shopping Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 6 & 7A BLK 10 PLAINVIEW SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Plainview' ,`TaxAmount` = '13161' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665583921' WHERE `Matrix_Unique_ID` = '207183758' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:31:18.923' ,`MLSNumber` = '75496010' ,`ListAgentFullName` = 'Glendi Ramos' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.772905' ,`Longitude` = '-95.162370' ,`PhotoCount` = '41' ,`PostalCode` = '77015' ,`RoomCount` = '7' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Muscatine' ,`StreetNumber` = '14625' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2240' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2018 constructed masterpiece ready for you to call home! 5 Bedrooms 3 bathrooms \r\nbrand new HVAC System , \r\nConveniently located close to I-10 with amazing conveniences within the area. Lots of potential to customize to your liking and make it your own!\r\nPer seller this home did NOT FLOOD, Measurements are approximate, buyer to verify the information.\r\nschedule your appointment today !' ,`Acres` = '0.1263' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 1 HOUSTON MANOR' ,`LotDesciption` = 'Other' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'SAM HOUSTON ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Chanel' ,`TaxAmount` = '3658' ,`TaxRate` = '2.5853' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583921' WHERE `Matrix_Unique_ID` = '208999458' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:27:02.027' ,`MLSNumber` = '29135759' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.386386' ,`Longitude` = '-95.024362' ,`PhotoCount` = '11' ,`PostalCode` = '77568' ,`RoomCount` = '5' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Century Oaks' ,`StreetNumber` = '513' ,`StreetSuffix` = 'Lane' ,`City` = 'La Marque' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2694' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous two-story home in Delany Cove. Walk into to be greeted with fresh interior paint and an open floor plan. The kitchen feature granite countertop with all stainless appliances (range, over range/oven microwave, and dishwasher). Band new carpets installed throughout the second floor, stairs, and all bedrooms. The home\'s backyard is your private oasis with a covered patio and a custom BBQ cooked-out pit and burners. Big backyard and fully fenced plus a utility shed for additional storage spaces. Greenspace behind the fence to provide extra privacy and no back neighbor. Move in ready and like new! All within 20 minutes to Galveston!' ,`Acres` = '0.1435' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 3 BLK 1 LANDING AT DELANY COVE SEC 5 (2018) ABST 2' ,`LotDesciption` = 'Other' ,`LotSize` = '6250' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Landing/Dolany Cove Sec 5' ,`TaxAmount` = '8319' ,`TaxRate` = '3.1135' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665583921' WHERE `Matrix_Unique_ID` = '209064871' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T06:26:27.810' ,`MLSNumber` = '93781147' ,`ListAgentFullName` = 'Marcy Voller' ,`ListOfficeName` = 'Hettig Management Corp.' ,`SellingAgentFullName` = 'Janine Dalcour' ,`SellingOfficeName` = 'Turner Mangum,LLC' ,`Latitude` = '29.581689' ,`Longitude` = '-95.597776' ,`PhotoCount` = '12' ,`PostalCode` = '77479' ,`RoomCount` = '7' ,`ListPrice` = '305000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Shawnee' ,`StreetNumber` = '3126' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2029' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated and well maintained one story in the heart of First Colony! This open floor plan home with 4 bedrooms and 2 baths is zoned to excellent schools, including Clements High School! Just minutes from Hwy 59, Hwy 6 and First Colony Mall!' ,`Acres` = '0.1597' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SETTLERS PARK SEC 1, BLOCK 8, LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6955' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SETTLERS WAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Settlers Park Sec 1' ,`TaxAmount` = '5360' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583921' WHERE `Matrix_Unique_ID` = '209129160' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T06:25:36.050' ,`MLSNumber` = '81925828' ,`ListAgentFullName` = 'Cindy Tomek' ,`ListOfficeName` = 'Full Stringer Realty' ,`SellingAgentFullName` = 'Will Borel' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '28.965683' ,`Longitude` = '-95.964092' ,`PhotoCount` = '50' ,`PostalCode` = '77414' ,`RoomCount` = '9' ,`ListPrice` = '299000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Tupperlake' ,`StreetNumber` = '2025' ,`StreetSuffix` = 'Lane' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3215' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A MOVE-IN READY RARE FIND! This well-loved 2 story, 5 bedroom home on tree-lined street is a must-see and PERFECT! No wide-angle lens needed here with 3215+sqft, the bedrooms, bathrooms & closets are huge! When you step into this well-built home, you immediately see it is graced with so many updates, a wide open floor plan and a spacious fenced backyard accented with the cutest gazebo. In their thirty years as the homeowners, the sellers have taken special care to keep this home very well-maintained and have added so many well-thought-of touches to make it their own. A few mentions are the added workshop behind detached garage, a barbecuing shed, storage barn, underground sprinkler system, two safes in primary closet, kitchen has stainless steel appliances, granite countertops, tile backsplash and cabinet pull-outs, retractable awnings off patio and garage, 30 year roof, new windows, siding. Big shoutout to the growing families...this one\'s for you! Buyer must be pre-qualified.' ,`Acres` = '0.241' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BAYWOOD S/D, BLOCK 1, LOT 24, SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = '' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Baywood Sub' ,`TaxAmount` = '5733' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583921' WHERE `Matrix_Unique_ID` = '209262225' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:10:58.690' ,`MLSNumber` = '56067345' ,`ListAgentFullName` = 'Renae Gibson' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.735586' ,`Longitude` = '-95.247042' ,`PhotoCount` = '46' ,`PostalCode` = '77547' ,`RoomCount` = '3' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = '4th' ,`StreetNumber` = '2213' ,`StreetSuffix` = 'Street' ,`City` = 'Galena Park' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story stunner that has been totally remodeled from the studs in 2016. Has separate living quarters. Main home has 3 beds and 1 bath; Guest home has 1 bed, 1 bath and it\'s own kitchen and it has been fully remodeled, as well. Beautiful wood floors. Large living room that is great for entertaining. Kitchen has lots of cabinets that have been custom glazed. Bedrooms are all large with room for lots of furniture. Guest quarters is modern and makes for perfect separate living space for renter or a loved one needing their own space. Roof replaced 2016. Bathroom remodeled 2021. Gorgeous oversized covered custom patio with rustic accented ceiling. Additional covered structure that makes for great outdoor bbq/picnic area. Huge backyard. Oversized driveway. Carport plus one car garage. Close to Downtown and Minute Maid. This property is a rare find in a great location.' ,`Acres` = '0.192' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 8 GALENA TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8365' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'GALENA PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'GALENA PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Galena Terrace' ,`TaxAmount` = '2636' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583922' WHERE `Matrix_Unique_ID` = '209653087' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:48:00.667' ,`MLSNumber` = '39066991' ,`ListAgentFullName` = 'Kate Myhan' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768032' ,`Longitude` = '-94.933387' ,`PhotoCount` = '29' ,`PostalCode` = '77521' ,`RoomCount` = '3' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Trailwood' ,`StreetNumber` = '3611' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated 3–4-bedroom home on an oversized pool sized backyard in one of Baytown\'s finest neighborhoods. Home features high vaulted ceilings in the living area, completely remodeled bathrooms with finishes (Refer to upgrades list) worthy of a home that is double the price, refinished kitchen cabinets with Misty black honed granite counters, fresh interior and exterior paint, recent roof (2016), HVAC (2017), water heater (2022) and more. Fully fenced backyard that could be ideal for kids and pets to play. Not in a flood zone and never flooded!' ,`Acres` = '0.2514' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 TRAILWOOD' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Trailwood' ,`TaxAmount` = '5396' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583922' WHERE `Matrix_Unique_ID` = '209810971' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:49:03.953' ,`MLSNumber` = '28927119' ,`ListAgentFullName` = 'Tod Franklin' ,`ListOfficeName` = 'DFWCityhomes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.660401' ,`Longitude` = '-95.578083' ,`PhotoCount` = '25' ,`PostalCode` = '77099' ,`RoomCount` = '9' ,`ListPrice` = '249000.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`='1665583922' WHERE `Matrix_Unique_ID` = '209820752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T06:14:22.463' ,`MLSNumber` = '81716467' ,`ListAgentFullName` = 'Charles Whittle' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.334451' ,`Longitude` = '-95.469692' ,`PhotoCount` = '17' ,`PostalCode` = '77301' ,`RoomCount` = '10' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Windswept' ,`StreetNumber` = '908' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1826' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly remodeled 4 bedroom 2 bath home centrally located inside Loop 336. House has been remodeled and updated. The kitchen has been completely redone with new cabinets and new stainless steel appliances. The kitchen also features a quarts counter top with lots of room to pull up stools. Corner lot with a very spacious back yard with mature trees for shade and an irrigation system to water it all.' ,`Acres` = '0.2257' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S864000 - SHADOW HILLS, LOT 9' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9830' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'REAVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Hills' ,`TaxAmount` = '3323' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583922' WHERE `Matrix_Unique_ID` = '210062274' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:12:30.383' ,`MLSNumber` = '29107363' ,`ListAgentFullName` = 'Jody Ricco' ,`ListOfficeName` = 'Ricco Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.949753' ,`Longitude` = '-95.366548' ,`PhotoCount` = '23' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = '8th' ,`StreetNumber` = '1414' ,`StreetSuffix` = 'Street' ,`City` = 'Freeport' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '951' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This adorable home has been completely remodeled and is move-in ready. The updated kitchen has gorgeous white cabinets and granite counter tops. The large island offers additional storage and the extended granite counter is perfect for barstools. Subway tile backsplash has a clean and modern feel. Stainless appliances are new and haven\'t been used. The bathroom has gorgeous tile in the oversized shower. New vanity and sink. Tile floors in the kitchen and bath. The hardwood floors have been refinished and look amazing! The electrical and plumbing systems have been updated. Recent front and back doors, sheetrock and paint. Pendant lighting, recessed lighting throughout living and kitchen. Attached garage. Large front yard and alley in back yard for garage access. Extended driveway provides additional parking. Foundation repaired January 2022.' ,`Acres` = '0.1607' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FREEPORT, BLOCK 155, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Freeport' ,`TaxAmount` = '1872' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1942' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583922' WHERE `Matrix_Unique_ID` = '210418262' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:47:39.280' ,`MLSNumber` = '29767824' ,`ListAgentFullName` = 'Ava Gutowski' ,`ListOfficeName` = 'Key 2 Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.990515' ,`Longitude` = '-95.323054' ,`PhotoCount` = '33' ,`PostalCode` = '77541' ,`RoomCount` = '5' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Elm' ,`StreetNumber` = '504' ,`StreetSuffix` = 'Street' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Waterfront Oyster Creek Home on 1/2 acre, Home has beautiful elevation and additional guest quarters with a shop! Fenced in back for pets! Large RV Awning. New Granite is on it\'s way for the Kitchen! This is a must see if you are wanting a Waterfront view, Shop and additional Guest quarters. The view and back yard offer serenity and peace. A great primary location to shop, get to the beach, boating and fishing!! PROPERTY HAS NEVER FLOODED!' ,`Acres` = '0.5378' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LINDA VISTA (A0009 B T ARCHER) (OYSTER CREEK) LOT 1-2' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '23427' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding 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` = 'Traditional' ,`Subdivision` = 'Linda Vista' ,`TaxAmount` = '4777' ,`TaxRate` = '2.2366' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583922' WHERE `Matrix_Unique_ID` = '210849359' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T06:37:30.960' ,`MLSNumber` = '23905318' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.469909' ,`Longitude` = '-95.463892' ,`PhotoCount` = '28' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Hearth Manor' ,`StreetNumber` = '806' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder! NEW CONSTRUCTION Cali Plan with Elevation L, features a modern design and offers 4 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, and stainless & steel appliances. Delight yourself in the primary bathroom, with dual sinks, separate shower, garden tub (on select inventory homes) and a large walk-in closet! (All information provided by builder). Located in Rosharon\'s newest DR Horton Community, Caldwell Ranch this gorgeous community will feature a resort-style pool, Covered Pavilion with Picnic Tables, Splash areas, Water Slides, Soccer Fields, and miles of walking trails. Visit our onsite sales center today!\r\n\r\nListing photos are of a similar floor plan. Finishes may vary and are subject to change.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R. HORTON, INC.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665583923' WHERE `Matrix_Unique_ID` = '210879336' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:25:05.527' ,`MLSNumber` = '82620824' ,`ListAgentFullName` = 'Chase Boeker' ,`ListOfficeName` = 'Marsae\'s Coastal Living Proper' ,`SellingAgentFullName` = 'Chase Boeker' ,`SellingOfficeName` = 'Marsae\'s Coastal Living Proper' ,`Latitude` = '29.453884' ,`Longitude` = '-94.631266' ,`PhotoCount` = '28' ,`PostalCode` = '77650' ,`RoomCount` = '3' ,`ListPrice` = '499000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Avenue H' ,`StreetNumber` = '1962' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2244' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptionally floor-planned three-bedroom 3 and 1/2-bathroom Beachside home with second floor living and spectacular views of the Gulf of Mexico. The home offers an open floor plan with a large open kitchen and dining area as well as an additional study, and all this opens up to an oversize second floor patio with loads of seating and entertaining area for all friends and family. Large bedrooms that each have their own bathrooms offer superior comfort and entertaining potential. Loads of potential for modifications and reworking of the downstairs driveway area.' ,`Acres` = '0.1221' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOT 46 HI POINT BEACH ADDN' ,`LotDesciption` = 'Other,Water View' ,`LotSize` = '5317' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Hi Point Beach Add' ,`TaxAmount` = '5825' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583923' WHERE `Matrix_Unique_ID` = '210973454' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T06:46:33.130' ,`MLSNumber` = '47001261' ,`ListAgentFullName` = 'John McDonald' ,`ListOfficeName` = 'Houston Home Store LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.965698' ,`Longitude` = '-95.206778' ,`PhotoCount` = '23' ,`PostalCode` = '77346' ,`RoomCount` = '5' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Great Forest' ,`StreetNumber` = '4118' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2246' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large Brick open concept home on Large lot. New Paint and Remodeled Bathrooms and Laminate throughout Quiet neighborhood close to shopping and parks. Large gameroom upstairs and private study on first floor. Spacious back yard with large cemented patio. Create the perfect outdoor haven. Come and see wont last long' ,`Acres` = '0.149' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 2 ATASCOCITA FOREST SEC 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6490' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WHISPERING PINES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita Forest Sec 16' ,`TaxAmount` = '5026' ,`TaxRate` = '2.773' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583923' WHERE `Matrix_Unique_ID` = '211098155' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T06:42:02.257' ,`MLSNumber` = '57526331' ,`ListAgentFullName` = 'Guadalupe Reed' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Guadalupe Reed' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.279705' ,`Longitude` = '-94.827233' ,`PhotoCount` = '20' ,`PostalCode` = '77551' ,`RoomCount` = '4' ,`ListPrice` = '219999.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = '57th' ,`StreetNumber` = '2114' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Get on Island Time and experience this charming home in Galveston, TX. With an inviting front porch and a quaint backyard, this home is ready for some R & R for its new owner. Wether you are looking to set roots in Galveston or Invest in a property please come see this home. Features ample free street parking. A less than five minute drive to the convention center, seawall, Pleasure Pier, and many other tourists spots on the island. Don\'t hesitate. Tour today. Buyers please do your due diligence.' ,`Acres` = '0.0689' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR N 60 FT OF LOTS 23 & 24 (23-1) BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Denver Resurvey' ,`TaxAmount` = '2807' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1937' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583923' WHERE `Matrix_Unique_ID` = '211436869' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:38:54.547' ,`MLSNumber` = '89342015' ,`ListAgentFullName` = 'Vicki Miller' ,`ListOfficeName` = 'RE/MAX Opportunities' ,`SellingAgentFullName` = 'Earle Chapa' ,`SellingOfficeName` = 'G & G Realty Texas LLC' ,`Latitude` = '29.555167' ,`Longitude` = '-95.788586' ,`PhotoCount` = '27' ,`PostalCode` = '77471' ,`RoomCount` = '6' ,`ListPrice` = '215000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Miles' ,`StreetNumber` = '1301' ,`StreetSuffix` = 'Street' ,`City` = 'Rosenberg' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1127' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well cared for 3 bed 1.5 bath home with 2 car attached garage located in the heart of Rosenberg and just minutes from food establishments, shopping, hospitals, and local schools. This home has neutral tile floors extended throughout, fresh paint, and a spacious floor plan. The kitchen has a built in microwave, dishwasher, crisp white cabinets to house all your kitchen essentials, and a nice breakfast room overlooking the backyard. All bedrooms are generous in size with ample closet space. The exterior consists of a nice covered patio, fenced backyard that backs to an alley, and beautiful mature trees that provide plenty of shade to the property. Don\'t miss this marvelous home on 1301 Miles Street! ' ,`Acres` = '0.1653' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TOBOLA S/D SEC 2, BLOCK 2, LOT 6' ,`LotDesciption` = 'Other' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'TERRY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO/GEORGE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tobola Sub Sec 2' ,`TaxAmount` = '2681' ,`TaxRate` = '2.0748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583923' WHERE `Matrix_Unique_ID` = '211574708' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:25:30.890' ,`MLSNumber` = '25237303' ,`ListAgentFullName` = 'Jason Gutierrez' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = 'Jauhar Mahmood' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.550646' ,`Longitude` = '-95.340429' ,`PhotoCount` = '26' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '300000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cloverfield' ,`StreetNumber` = '2611' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1865' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 3 bedroom, 2 bathroom house has a new driveway that leads up to a freshly painted exterior. Inside you will find many new updates including both bathrooms, new tile through the house, and freshly painted walls. Pearland ISD. Book your appointment today.' ,`Acres` = '0.2112' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHWYCK, BLOCK 4, LOT 19 SEC 1-REPLAT, A0242 HT&BRR' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SILVERLAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwyck' ,`TaxAmount` = '5253' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583923' WHERE `Matrix_Unique_ID` = '211671388' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:55:42.703' ,`MLSNumber` = '46312529' ,`ListAgentFullName` = 'Lana Keeney' ,`ListOfficeName` = 'Texas Legacy Properties' ,`SellingAgentFullName` = 'Thao Dao' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.017823' ,`Longitude` = '-95.633124' ,`PhotoCount` = '47' ,`PostalCode` = '77429' ,`RoomCount` = '9' ,`ListPrice` = '599999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Silver Willow' ,`StreetNumber` = '15007' ,`StreetSuffix` = 'Circle' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3127' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CUSTOM BUILT K Hovnanian Home, nestled in the highly sought after gated community of Enclave at Northpointe. This spacious 2 story home features 4 bedrooms, 4 full bathrooms and sits on a cul-de-sac lot that boasts over a 14,000 square feet. Two bedrooms down-primary & a secondary with private bathroom. Primary bedroom suite includes custom his and her walk-in closets, dual vanity, granite countertops, separate over-sized walk in shower & soaking tub. Open living area has stone wall fireplace w/ floating mantle; crown molding throughout; 5” wood/tile flooring. The huge island kitchen has 42” cabinets, granite counters, double oven, gas stove and upgraded fixtures. Two bedrooms upstairs with private bathrooms plus expansive gameroom. The backyard oasis includes pool, hot tub, extended cedar planked covered patio with stamped concrete, updated lamp fans and gas connection for an outdoor kitchen. Home is equipped with full home security system & cameras surrounding entire exterior.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 Block 3 Enclave at Northpointe Sec 6' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '14151' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1155' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave at Northpointe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583924' WHERE `Matrix_Unique_ID` = '211728699' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:54:24.343' ,`MLSNumber` = '21693547' ,`ListAgentFullName` = 'Tawni Slaughter' ,`ListOfficeName` = 'Stanfield Properties' ,`SellingAgentFullName` = 'Shanisha Greer' ,`SellingOfficeName` = 'Greer Real Estate Solution' ,`Latitude` = '29.381847' ,`Longitude` = '-95.001752' ,`PhotoCount` = '29' ,`PostalCode` = '77591' ,`RoomCount` = '12' ,`ListPrice` = '375000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Amburn' ,`StreetNumber` = '115' ,`StreetSuffix` = 'Road' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2466' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ranch-style home with a pool on an unrestricted 1.8-acre lot dotted with mature oak & pecan trees for shade! This charming stone & brick bungalow boasts spacious living & dining rooms with cased windows, an inviting breakfast room with a built-in buffet, and a must-see updated kitchen with a butcher block island, abundant white cabinetry, a glass tile backsplash, & recently replaced appliances. The home offers 3 bedrooms, 3.5 baths, tons of storage with cedar-lined closets, and a custom built-in bed in the hall bedroom. Step through the mudroom to the huge outdoor deck overlooking the pool, spa, & tiki hut bar. A great space for entertaining! The property also features multiple storage buildings, including one that is air-conditioned, a 2 car garage, a second driveway that could be used for boat or RV storage, and a 1 bedroom/1 bath cottage in the back that needs repairs. With no HOA restrictions, the possibilities are endless!' ,`Acres` = '1.824' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 2 S F AUSTIN SUR PT OF LOT 15 (15-1) AMBURN SUB' ,`LotDesciption` = 'Cleared' ,`LotSize` = '79453' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'SIMMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Amburn Sub N Ih 45' ,`TaxAmount` = '4509' ,`TaxRate` = '2.582' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583924' WHERE `Matrix_Unique_ID` = '211746099' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:23:30.477' ,`MLSNumber` = '96151289' ,`ListAgentFullName` = 'Estella Dawson' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.345142' ,`Longitude` = '-95.317302' ,`PhotoCount` = '38' ,`PostalCode` = '77303' ,`RoomCount` = '3' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Kingsbury' ,`StreetNumber` = '16558' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1428' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous new construction! Updated Price and Updated Pics! Come take a look at this beautiful single story home. This one has so many features. Spacious kitchen with an extended granite island with a built in trash bin, split bedroom plan features a primary suite on one end of the home and the secondary rooms at the other. Primary bath is luxurious and closet has custom shelving. High ceilings give this home a large spacious feel. Laundry room is conveniently located inside. Notice the double size driveway makes it convenient for parking. Nice size patio off the back door and a attached garage. All this on a very generous size lot. Now ready for move in!\r\nDon\'t wait, call today for a private tour!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Baquedano' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Crockett Trace Estates 11, LOT 9, Block 03' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crockett Trace' ,`TaxAmount` = '' ,`TaxRate` = '2.2' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665583924' WHERE `Matrix_Unique_ID` = '211857678' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:19:40.237' ,`MLSNumber` = '10881364' ,`ListAgentFullName` = 'Kirk Williams' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.235810' ,`Longitude` = '-95.172073' ,`PhotoCount` = '50' ,`PostalCode` = '77372' ,`RoomCount` = '7' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Goodson' ,`StreetNumber` = '25429' ,`StreetSuffix` = 'Road' ,`City` = 'Splendora' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3497' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this amazing property in Splendora! This never flooded (per seller) home has 2 remodeled homes on almost 19 acres! Main home is a ranch-style with 3 bedrooms, 2 full baths all one story. Gorgeous vinyl plank through most of the home with new carpet in secondary bedrooms. Custom cabinetry, quartz counters, stainless steel appliances adorn this open kitchen. Vaulted ceiling in living room with wood burning fireplace! Both bathrooms are completely updated with gorgeous walk-in showers! Tankless hot water heater! Bring the mother-in-law, older children or another family to the completely remodeled second home just behind main home! Includes 2 bedrooms, gorgeous full kitchen, living, study, 1 full bath and half bath. Also, could be used as office quarters! Attached to second home is a 30x30 workshop! In backyard, entertain the whole family under a 20x30 pavilion with electricity. Tons of space to roam with 2 ponds, dirt bike/horse trails and lots of woods!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0082 BARKER WM, TRACT 39, ACRES 2.000' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '824808' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PINEY WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '4155' ,`TaxRate` = '2.4206' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583924' WHERE `Matrix_Unique_ID` = '211944588' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:25:10.190' ,`MLSNumber` = '62338311' ,`ListAgentFullName` = 'Tina Langford' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.547697' ,`Longitude` = '-95.056944' ,`PhotoCount` = '40' ,`PostalCode` = '77565' ,`RoomCount` = '8' ,`ListPrice` = '490000.00' ,`Status` = 'Active' ,`StreetName` = 'Dillonwood' ,`StreetNumber` = '2086' ,`StreetSuffix` = 'Court' ,`City` = 'Kemah' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3308' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hurry! This beauty won’t last long - it truly has it all! The grand entrance with wrought iron double doors lead into the elegant foyer, featuring a wrought iron staircase. The primary bedroom is downstairs with 3 secondary bedrooms, a game room, and fully equipped media room upstairs. The office and formal dining open to the living room, kitchen, and breakfast area. The kitchen is spacious and features an island and granite countertops. Whether you enjoy entertaining or relaxing, the back yard oasis is a tropical dream! Take a dip in the saltwater pool or relax in the Strongspa jacuzzi. Invite friends and family to lounge under the gazebo with ceiling fan, surrounded by a bamboo fence with tiki lights. Must see to believe!!' ,`Acres` = '0.1481' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TWIN OAKS SUB SEC 2 (2007) ABST 18, BLOCK 1, LOT 11' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6451' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas 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,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Twin Oaks Sub Sec 2 2007' ,`TaxAmount` = '7961' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583924' WHERE `Matrix_Unique_ID` = '212156432' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:46:25.790' ,`MLSNumber` = '72878752' ,`ListAgentFullName` = 'Yohan Adhitama' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887713' ,`Longitude` = '-95.436171' ,`PhotoCount` = '24' ,`PostalCode` = '77088' ,`RoomCount` = '7' ,`ListPrice` = '241900.00' ,`Status` = 'Active' ,`StreetName` = 'Drayton' ,`StreetNumber` = '2123' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1962' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely one story house with 4 beds and 2 baths. Tons of upgrade. Fresh interior paint, new roof, new HVAC, new Quartz countertops and backsplash, new gas oven, new cooktop, new light fixture, new kitchen sink & faucet, new mirror, & new dishwasher. Easy access to I-45 & Hwy. 249, & also 610. Schedule your showing today.' ,`Acres` = '0.1515' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 836 BLK 26 HEATHER GLEN SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'HILL ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heather Glen Sec 03' ,`TaxAmount` = '3075' ,`TaxRate` = '2.1553' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583925' WHERE `Matrix_Unique_ID` = '212158762' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:31:19.610' ,`MLSNumber` = '67047803' ,`ListAgentFullName` = 'Doris Hernandez Garcia' ,`ListOfficeName` = 'CENTURY 21 Western Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.706087' ,`Longitude` = '-95.851647' ,`PhotoCount` = '36' ,`PostalCode` = '77441' ,`RoomCount` = '9' ,`ListPrice` = '469000.00' ,`Status` = 'Active' ,`StreetName` = 'Caldwell Sky' ,`StreetNumber` = '27502' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 Bed/3 Bath. in the heart of Cross Creek Ranch, you\'ll love the fabulous Open floor Plan, design with 12-foot coffered ceilings in entry and extended entry, with Stunning kitchen wide open to the family room and has Huge island. This floor plan has so many great options. One of the bedrooms is perfect for a Guest Suit with private Bath included. Upgrades throughout the Home, Granite! Wood laminate in all bedrooms! Crown Molding! Extended back Patio, fresh paint, Sprinklers!' ,`Acres` = '0.1641' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK BEND AT CROSS CREEK RANCH SEC 2, BLOCK 1, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JAMES E RANDOLPH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creek Bend At Cross Creek Ranch Sec 2' ,`TaxAmount` = '11572' ,`TaxRate` = '3.1375' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583925' WHERE `Matrix_Unique_ID` = '212218498' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:56:04.823' ,`MLSNumber` = '63992938' ,`ListAgentFullName` = 'Maria Giovinale' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.161089' ,`Longitude` = '-95.151301' ,`PhotoCount` = '7' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Galaxy' ,`StreetNumber` = '19253' ,`StreetSuffix` = 'Boulevard' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 19253. Galaxy Blvd!! This gorgeous new construction home is surrounded by beautiful green scenarios and located inside a very peaceful and quiet neighborhood. The house has 10’ ceilings in the kitchen and living areas and an open concept floorplan which integrates perfectly all the common areas making it perfect for entertaining. The kitchen is equipped with 42” upper cabinets, a large functional kitchen island and granite countertops. The bedrooms have large and spacious walk-in closets. It comes with the Samsung Stainless Steel package including easy clean top range with electric oven, 3 racks dishwasher and microwave. Buyer will obtain 1 year warranty on appliances from Samsung. Come and see this beautiful home!' ,`Acres` = '0.51' ,`Area` = '40' ,`BuilderName` = 'Starter Homes of TX' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'KINGS COLONY 01, BLOCK 2, LOT 29, ACRES 0.510' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '22215' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '180' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Colony 01' ,`TaxAmount` = '22' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665583925' WHERE `Matrix_Unique_ID` = '212364922' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:22:24.940' ,`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`='1665583925' WHERE `Matrix_Unique_ID` = '212414088' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:16:38.407' ,`MLSNumber` = '32958822' ,`ListAgentFullName` = 'LaWanda Lendsey' ,`ListOfficeName` = 'Houston Home Realty Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.539044' ,`Longitude` = '-95.488896' ,`PhotoCount` = '30' ,`PostalCode` = '77545' ,`RoomCount` = '11' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Farrel Hill' ,`StreetNumber` = '3223' ,`StreetSuffix` = 'Street' ,`City` = 'Fresno' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3156' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home sweet home! Are you looking to be near dining, pharmacies, shopping, entertainment, the Fortbend Toll, Pearland, and/or Manvel? This is it? Home is a few blocks from the neighborhood park, tennis, and picnic, and pool area. Very spacious 3156 sqft very open 2 story 4 bedroom, 3 full baths & a half, 2 car garage w/ large game room, curved staircase, & vaulted ceilings. Downstairs primary bedroom is large & has a bay window. The primary bathroom has double vanities, granite counter tops , 2 large closets, separate shower & jet spa tub. Large kitchen has an extended bar area, stainless steel appliances, granite counter tops, butler\'s prep area, 42 inch cabinets, tiled backsplash, recess lighting, desk area in the kitchen, with 2 box windows for extra light as well. This home also offers an upstairs game room & study/office space as well. 2 of the upstairs bedrooms has an adjoining bathroom area. Neighborhood offers trails, pool, playgrounds, & tennis courts. Call today!' ,`Acres` = '0.1323' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WINFIELD LAKES SEC 2, BLOCK 3, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5764' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PARKS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Winfield Lakes Sec 2' ,`TaxAmount` = '6058' ,`TaxRate` = '2.4829' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583925' WHERE `Matrix_Unique_ID` = '212510751' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T06:52:34.330' ,`MLSNumber` = '42705131' ,`ListAgentFullName` = 'Willie Ragasa' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'Matthew Socha' ,`SellingOfficeName` = 'Texas United Realty' ,`Latitude` = '29.589332' ,`Longitude` = '-95.578131' ,`PhotoCount` = '28' ,`PostalCode` = '77459' ,`RoomCount` = '4' ,`ListPrice` = '329500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wavertree' ,`StreetNumber` = '4514' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED! One story on corner lot with hardwoods in formal living and dining rooms. Updates include granite in kitchen and baths, recent exterior and interior paint. Double fireplace between living and den. Lovely backyard with large deck and pergola perfect for outdoor entertaining. Easy access to major highways, grocery stores and schools. Buyer to verify all room sizes and schools.' ,`Acres` = '0.1565' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PLANTATION CREEK SEC 2-A, BLOCK 3, LOT 21' ,`LotDesciption` = 'Corner' ,`LotSize` = '6815' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '812' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEXINGTON CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Plantation Creek Sec 2-A' ,`TaxAmount` = '6711' ,`TaxRate` = '2.71' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583926' WHERE `Matrix_Unique_ID` = '212575715' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:46:42.603' ,`MLSNumber` = '45012130' ,`ListAgentFullName` = 'Yohan Adhitama' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.690542' ,`Longitude` = '-95.067822' ,`PhotoCount` = '38' ,`PostalCode` = '77571' ,`RoomCount` = '8' ,`ListPrice` = '314900.00' ,`Status` = 'Active' ,`StreetName` = 'Robinson' ,`StreetNumber` = '912' ,`StreetSuffix` = 'Road' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely one story house with 3 beds and one extra large room that can be turned into another bedroom. This wonderful home is sitting on large lot. Previous seller said the house is 2,644 sq. ft., the garage was converted into a recreational & separate laundry room. Nice size family room with fireplace, built-in shelf, and high ceiling. Cozy screen porch/patio. Oversize carport 24X48. Quiet neighborhood. Tons of upgrade. Fresh interior & exterior paint, new roof, new bathroom tile, new vinyl flooring, new Quartz countertops and backsplash, new light fixture, new cooktop, new kitchen sink & faucet, & new mirror. Easy access to Hwy. 225 & Hwy. 146. Schedule your showing today.' ,`Acres` = '0.4289' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lomax Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 410 411 & 412 BLK 11 BATTLEGROUND ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18681' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LOMAX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Battleground Estates Sec 02' ,`TaxAmount` = '5812' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583926' WHERE `Matrix_Unique_ID` = '212592742' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T06:40:38.377' ,`MLSNumber` = '98351761' ,`ListAgentFullName` = 'Debra Fewox' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.325964' ,`Longitude` = '-94.939136' ,`PhotoCount` = '38' ,`PostalCode` = '77563' ,`RoomCount` = '6' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Warsaw' ,`StreetNumber` = '650' ,`StreetSuffix` = 'Street' ,`City` = 'Bayou Vista' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1752' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL HOME In BAYOU VISTA Recently remodeled w/ Roof, Bulkhead, Sept 2022 Electric Book Lift & Boat House , Aug 2022Concrete Parking added for 4 cars, Concrete Patio Extended across rear of home, gorgeous ceramic plank floors & LED lighting. Gourmet kitchen new cabinets, SS appliances & fabulous white quartz countertops. Large Primary & Guest bedroom plus 1.5 Bathrooms w/walk-in shower &Laundry connections upstairs. Downstairs is a 1 bedroom apartment w/AC, full bath, laundry room plus a large Living Rm &kitchen. Additional upgrades: high efficiency windows & sliding doors, paint in & out, lights, fans & switches, shiplap wall in Upstairs Living Area, etc. Party upstairs & enjoy the breeze or go downstairs to your pier/boathouse area & feed the Pelican and ducks, catch a fish, enjoy swimming or go out on your boat, is just a way of life in Bayou Vista. Buyer verify all information .Downstairs fully furnished, Upstairs Seller will leave Living Room Sofas and Chair n Ottoman' ,`Acres` = '0.1062' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Gas,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 PAGE 7 LOT 650 NEW BAYOU VISTA ADDN 5' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '4625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '16' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'New Bayou Vista 5' ,`TaxAmount` = '' ,`TaxRate` = '2.635' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583926' WHERE `Matrix_Unique_ID` = '212627284' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T06:52:52.270' ,`MLSNumber` = '21007467' ,`ListAgentFullName` = 'Renae Gibson' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811880' ,`Longitude` = '-95.401230' ,`PhotoCount` = '37' ,`PostalCode` = '77008' ,`RoomCount` = '5' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = '28th' ,`StreetNumber` = '258' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2212' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NO HOA FEES. 3 story corner home on premium lot with nice sized yard. Very rare find. Primary bedroom located on 3rd floor and it looks like an upscale luxury suite. Primary bathroom has large shower and separate garden soaking tub. Long vanity gives you great space to prepare for your day. Second bedroom w private bathroom plus laundry also on the 3rd floor. There is another bedroom on 1st floor with full bath that includes a large shower. Home has been painted inside with modern updated designer colors. Chef\'s kitchen that has custom cabinetry, large island, stainless appliances and granite countertops. Updated backsplash, handles and faucets throughout. Custom wet bar with wine fridge are here and the formal dining will accommodate large gatherings. Notice the updated light fixtures. Living room boasts wood flooring and is a great entertaining space. Half bath with upscale wallpaper make this home truly a custom home. 5 minutes to hike/bike trail, shopping and great restaurants.' ,`Acres` = '0.0415' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 1 ERIN PARK ON WEST 28TH STREET' ,`LotDesciption` = 'Corner' ,`LotSize` = '1807' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Erin Pk/West 28th Street' ,`TaxAmount` = '10408' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583926' WHERE `Matrix_Unique_ID` = '212667750' --> 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','212727049','1665583926','212727049','2022-10-12T07:51:23.683','21290681','Barbie Tucker','Etheredge Real Estate','','','29.399685','-94.911891','13','77590','7','325000.00','Active','15th','1208','Avenue','Texas City','2','1','3','2786','Single-Family','Few lots in Texas City can compare to this one. Extraordinary windows showcase this beautiful yard, complimented with an oversized pool with diving board in the back and a gorgeous Oak in the front. The home is accented with custom lighting and custom gate, leaf filter gutters. Step back to the 70\'s in this completely updated mid-century modern ranch style home. This home is meant to entertain in. TONS of storage! Large open kitchen with a bar to the den, separate ice maker and lots of counters prep space. Bedrooms are secluded from the living side of the home for privacy. Mud room separates the garage from the home with a 1/2 bath for the pool. Roof replaced 2020, HVAC (inside unit) and ducts replaced 2021, AC compressor (outside unit) replaced 2022 MORE PICTURES 10/13','0.4924','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Owner/Agent','1','','','Texas City','Central Gas','0','ABST 167 PAGE 2 LOT 27 & W PT OF LOT 26 & ADJ 30 FT TRACT SU','Cul-De-Sac','21449','Appraisal District','','','0','','2','Electric Oven','1','Gunite,In Ground,Salt Water','','Gas Cooktop','','Composition','52 - Texas City','KOHFELDT ELEMENTARY SCHOOL','TEXAS CITY HIGH SCHOOL','BLOCKER MIDDLE SCHOOL','Appointment Required','Seller','1','Other Style','Sunset Terrace','5085','2.5335','Public Sewer,Public Water','1971','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:56:34.667' ,`MLSNumber` = '18006068' ,`ListAgentFullName` = 'Deborah Bly' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.511009' ,`Longitude` = '-95.036487' ,`PhotoCount` = '25' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '329500.00' ,`Status` = 'Active' ,`StreetName` = 'Windy Cape' ,`StreetNumber` = '3207' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2196' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS PROPERTY IS LOCATED IN THE VERY SOUGHT-AFTER CCISD SCHOOL DISTRICT IN SOUTH SHORE HARBOR.IT FEATURES FOUR BEDROOMS, TWO & A HALF BATH, TWO CAR ATTACHED GARAGE. TRAVERTINE THROUGHOUT THE DOWNSTAIRS, STAINLESS STEEL APPLIANCES, PLUS PLENTY OF KITCHEN CABINETS AND COUNTER SPACE. LARGE BACKYARD WITH PATIO AND PERGOLA PERFECT FOR GATHERS AND ENTERTAINING. PRIMARY BATHROOM HAS CUSTOM QUARTZ COUNTERTOPS AND A TILED SHOWER. SECONDARY BATHROOM HAS CUSTOM TILING AND A LARGE SHOWER. NEVER FLOODED AND IS NOT IN A FLOOD ZONE. CLOSE TO KEMAH, ENTERTAINMENT, DINING, SHOPPING AND A SHORT DRIVE TO GALVESTON. EASY ACCESS TO I-45. SELLER HAS A ESTIMATE FOR REPLACING THE CARPET' ,`Acres` = '0.1447' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTH SHORE HARBOUR SEC SF 50-1 (2003) ABST 18, BLOCK 2, LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6303' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HYDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Shore Harbour Sec Sf 50' ,`TaxAmount` = '6640' ,`TaxRate` = '2.4521' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583926' WHERE `Matrix_Unique_ID` = '212859878' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:15:34.633' ,`MLSNumber` = '79344002' ,`ListAgentFullName` = 'Yolanda McCraw Cunningham' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.561533' ,`Longitude` = '-95.256476' ,`PhotoCount` = '40' ,`PostalCode` = '77581' ,`RoomCount` = '11' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden Creek' ,`StreetNumber` = '2504' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2212' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here’s your opportunity to own in the highly sought-after community of Clear Creek Park. A true gem, this immaculate 1 story, 3 bedroom, 2 bath home has been recently updated with granite counters, interior painting, LVP flooring in Primary bedroom, primary bath, and walk-in closet; new built-in oven, cooktop and vent hood, and much more. The refrigerator is included with the sale. Also the washer and dryer. The primary bath features dual vanities, separate garden tub and shower, and private toilet closet. This home is equipped with a home generator for added security and comfort when power goes down. Whether you’re entertaining or looking for a bit of R&R, this home meet the need.. Book an appointment soon. Room sizes are approximate; Buyers to verify.' ,`Acres` = '0.195' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CLEAR CREEK PARK (A0198 TJ GREEN) (PEARLAND) BLK 2 LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8494' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '407' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SHADYCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Creek Park' ,`TaxAmount` = '8491' ,`TaxRate` = '2.8451' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583927' WHERE `Matrix_Unique_ID` = '212869321' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:57:54.550' ,`MLSNumber` = '97112529' ,`ListAgentFullName` = 'Carlisle Bakondy' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Steven Kinne' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.816656' ,`Longitude` = '-95.386356' ,`PhotoCount` = '18' ,`PostalCode` = '77022' ,`RoomCount` = '3' ,`ListPrice` = '425000.00' ,`Status` = 'Option Pending' ,`StreetName` = '33rd' ,`StreetNumber` = '921' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1701' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful single-family home built in 2018! 3 Bedroom, 2.5 Bath. Tons of natural light! Wood floors throughout and tile in baths. Gorgeous kitchen with an open concept! Stainless steel appliances, gas range, walk-in pantry. Awesome backyard with artificial turf, French drain and a HUGE covered patio with a ceiling fan! Perfect for entertaining! Super close to Whole Foods 365! Call today to schedule a tour, this is a MUST see!!' ,`Acres` = '0.064' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 37 BLK 12 LINCOLN HEIGHTS 2ND AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2790' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Lincoln Heights Amd #2' ,`TaxAmount` = '6509' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583927' WHERE `Matrix_Unique_ID` = '212951405' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T06:43:03.203' ,`MLSNumber` = '90236551' ,`ListAgentFullName` = 'Shannon Binder' ,`ListOfficeName` = 'Binder Real Estate, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701059' ,`Longitude` = '-96.546026' ,`PhotoCount` = '13' ,`PostalCode` = '78962' ,`RoomCount` = '4' ,`ListPrice` = '219000.00' ,`Status` = 'Active' ,`StreetName` = 'Bonham' ,`StreetNumber` = '926' ,`StreetSuffix` = '' ,`City` = 'Columbus' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.147' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Blk 69 S13 House' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '188 - Columbus' ,`SchoolElementary` = 'COLUMBUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLUMBUS HIGH SCHOOL' ,`SchoolMiddle` = 'COLUMBUS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'None' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583927' WHERE `Matrix_Unique_ID` = '212954283' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:58:50.993' ,`MLSNumber` = '52978516' ,`ListAgentFullName` = 'Cesar Espinoza' ,`ListOfficeName` = 'Equity Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.693114' ,`Longitude` = '-95.505788' ,`PhotoCount` = '44' ,`PostalCode` = '77074' ,`RoomCount` = '3' ,`ListPrice` = '297000.00' ,`Status` = 'Active' ,`StreetName` = 'Bintliff' ,`StreetNumber` = '7822' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious updated single-story home located in the established community of Sharpstown. Home features 3 bedrooms & 1.5 bathrooms! It has a spacious living area that flows into the kitchen. New flooring throughout the main areas and in all the bedrooms. New paint throughout the home. The bathrooms have been completely remodeled. Blocks from Bayland Park with walking trails, sports fields, a park, pavilion & more. Zoned to Houston ISD schools & walking distance to Sutton Elementary School! Location of this home is ideally located close to endless premier shopping, dining, entertainment, & major freeways for an easy commute.' ,`Acres` = '0.1887' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 42 SHARPSTOWN SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8220' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SUTTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'LONG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharpstown Sec 02' ,`TaxAmount` = '3037' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583927' WHERE `Matrix_Unique_ID` = '213000454' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:12:05.317' ,`MLSNumber` = '83763856' ,`ListAgentFullName` = 'Eric Beeler' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.011975' ,`Longitude` = '-95.471203' ,`PhotoCount` = '32' ,`PostalCode` = '77068' ,`RoomCount` = '11' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Amcreek' ,`StreetNumber` = '16314' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3047' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this fully remodeled 1 story Gem on nearly ½ acre in the established Bammel Forest. Step inside from your large front covered patio and find large windows and open space. This spacious home has 4 bedrooms, 2.5 bathrooms and a built in generator. The Kitchen is the true stand out in this home. Custom cabinets with gorgeous Granite counter tops. So much storage with space to prepare and entertain. There is an eat in area for a breakfast table as well. There is a formal living room and a family room with built in cabinets and a dining area. All bedrooms have ample closet space as well as multiple storage closets in the hall. The primary bedroom boasts an ensuite bathroom with walk in shower and huge closet. But the BEST feature is the screened in pool with covered patio, so much room for fun and family! And still so much greenspace to run and play in the yard. Outdoor mancave/workshop with a/c completes the outdoors. Come see this Beautiful Home today.' ,`Acres` = '0.5165' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BAMMEL FOREST SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '22500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PONDEROSA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Bammel Forest Sec 01' ,`TaxAmount` = '3986' ,`TaxRate` = '2.0892' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583927' WHERE `Matrix_Unique_ID` = '213043033' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:06:05.833' ,`MLSNumber` = '16117564' ,`ListAgentFullName` = 'Tara Anderson' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.620563' ,`Longitude` = '-95.598796' ,`PhotoCount` = '4' ,`PostalCode` = '77478' ,`RoomCount` = '8' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Country Club' ,`StreetNumber` = '2513' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1927' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1731' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 27, LOT 4' ,`LotDesciption` = 'In Golf Course Community,Patio Lot' ,`LotSize` = '7540' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DULLES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Creek Sec 27' ,`TaxAmount` = '4932' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583927' WHERE `Matrix_Unique_ID` = '213084549' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:57:04.023' ,`MLSNumber` = '72441407' ,`ListAgentFullName` = 'Melissa Kubala' ,`ListOfficeName` = 'Boulevard Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.784740' ,`Longitude` = '-95.375719' ,`PhotoCount` = '41' ,`PostalCode` = '77009' ,`RoomCount` = '10' ,`ListPrice` = '1525000.00' ,`Status` = 'Active' ,`StreetName` = 'Byrne' ,`StreetNumber` = '417' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3675' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Offered soon is a new construction built by the team at the Modern Bungalow Company on popular Byrne street. On a pier and beam foundation, the property offers 4 bedroom & 4 bathrooms with a large but private gameroom up. Study down can be a 5th bedroom and has full bath. A classic black and white color schematic & black steel shed roof are distinctive features of this modern farmhouse influenced elevation. Professional kitchen appliances include 48” Fisher Paykel Pro Gas Range, 60\" Frigidaire Professional Side by Side refrigerator & Fisher Paykel Double Drawer Pro Style Dishwasher. All custom millwork and finish selections were selected by the Modern Bungalow design team and offer a fresh and new interpretation of modern farmhouse style.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = 'The Modern Bungalow' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 12 WOODLAND HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Craftsman,Other Style,Traditional' ,`Subdivision` = 'Woodland Heights' ,`TaxAmount` = '9780' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665583928' WHERE `Matrix_Unique_ID` = '213103769' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:35:27.397' ,`MLSNumber` = '59300654' ,`ListAgentFullName` = 'Tanna Villarreal' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839874' ,`Longitude` = '-95.429745' ,`PhotoCount` = '27' ,`PostalCode` = '77018' ,`RoomCount` = '8' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Del Norte' ,`StreetNumber` = '1206' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1916' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will love this beautifully updated and maintained single story ranch in the highly desirable neighborhood of Ella Lee Forest! Zoned to the acclaimed Oak Forest Elementary, you simply won\'t find a more stunning place to call your own. With its three bedrooms, two baths, study, dining and family room, there is plenty of space for all. The real charmer, though, is the amazingly lush backyard with your own swimming pool and spa! Updates include PEX Plumbing, pool Gunite, remodeled bathrooms and kitchen, roof in the last 4 years. Ready to move in!' ,`Acres` = '0.2277' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 06 BLOCK A' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '9917' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Ella Lee Forest' ,`TaxAmount` = '10033' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583928' WHERE `Matrix_Unique_ID` = '213151912' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:51:08.393' ,`MLSNumber` = '32748041' ,`ListAgentFullName` = 'Kathy Krimsky' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843527' ,`Longitude` = '-95.551310' ,`PhotoCount` = '43' ,`PostalCode` = '77041' ,`RoomCount` = '8' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Shadowdale' ,`StreetNumber` = '10422' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2273' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautiful and unique 1 story home with special features to make it wheelchair accessible, ADA compliant and VA approved. Featuring whole house generator & solar panels to take you through any weather emergency in comfort. Stunning ceramic tiles throughout the open concept floor plan & hardwood tiles in most bedrooms and den, with amazing bath tile work. Home features 2 primary bedrooms with en-suite baths, plus another full bath (all with granite counters), 4 or 5 bedrooms, study. Home has storage galore & built-ins you must see to believe. Kitchen boasts granite counters, stainless steel appliances, and large moveable island. Cozy den opens on 1 side to handicapped suite and back door exits to covered patio. This area adds to living space, perfect for morning coffee or dining alfresco. Twinkling lights above make this a magical pace to relax after dark. Ring doorbell, Kuna security light with camera & interactive communications module. Arrange a showing today!' ,`Acres` = '0.1386' ,`Area` = '24' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 4 WESTBRANCH SEC 2 PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6039' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '271' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbranch Sec 02 Prcl R/P' ,`TaxAmount` = '7166' ,`TaxRate` = '2.5842' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583928' WHERE `Matrix_Unique_ID` = '213165306' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:13:10.150' ,`MLSNumber` = '90310812' ,`ListAgentFullName` = 'Lynda Moreland' ,`ListOfficeName` = 'Texans Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151363' ,`Longitude` = '-95.411257' ,`PhotoCount` = '14' ,`PostalCode` = '77385' ,`RoomCount` = '9' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Midlake Park' ,`StreetNumber` = '31827' ,`StreetSuffix` = 'Park' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2429' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful updated 1 1/2 story home on long cul-de-sac, many updates, large yard. Upstairs bonus room could be the perfect playroom, game room or media room. Large Primary bedroom and three additional rooms all downstairs in a split floorplan. Computer nook located at the front of the home. Great for home office of student studies. Formal Dinging and/or Formal Living for entertaining family and friends. Book your showing now as this one wont\' last long.' ,`Acres` = '0.1849' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPERIAL OAKS PARK 04, BLOCK 1, LOT 33' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8054' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks Park 04' ,`TaxAmount` = '5372' ,`TaxRate` = '2.4827' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583928' WHERE `Matrix_Unique_ID` = '213181979' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T06:33:25.107' ,`MLSNumber` = '15455462' ,`ListAgentFullName` = 'Hector Rodriguez' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.102878' ,`Longitude` = '-95.530705' ,`PhotoCount` = '22' ,`PostalCode` = '77389' ,`RoomCount` = '5' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Walnut Maze' ,`StreetNumber` = '23706' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1795' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story home in a cul-de-sac in the charming neighborhood of Preserve at Northampton. Spacious home with 3 beds, 2 baths and a 2 car garage. Gorgeous flooring throughout enhances the beauty of this well cared-for home! The living room has plenty of natural light and a gas log fireplace. The kitchen has ample storage, granite countertops and a large pantry. The primary room has a built-in wall storage/TV stand and a large en-suite bath with walk-in shower and a walk-in closet. \nEnjoy the outdoors in the covered patio with ceiling fans and plenty of yard space to host. \n\nYour new home awaits! ' ,`Acres` = '0.1361' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 3 PRESERVE AT NORTHAMPTON SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5930' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NORTHAMPTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Preserve/Northampton Sec 4' ,`TaxAmount` = '6124' ,`TaxRate` = '2.834' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583928' WHERE `Matrix_Unique_ID` = '213193652' --> 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','213253009','1665583929','213253009','2022-10-12T06:30:36.643','43229080','Christal Amboree','Realty ONE Group, Experience','','','30.292681','-95.485052','28','77304','6','264600.00','Active','Epworth','1123','Court','Conroe','2','0','3','1707','Single-Family','Welcome to the Cayden Creek subdivision! Come and see why this charming 3 bedroom 2 bathroom house is one you\'ll love to call home. Enjoy your family while relaxing in the comfort of your open concept living room/kitchen or entertain some friends in your large backyard with a covered patio. Neighborhood playground and dog park. All appliances included and new carpet in primary bedroom!\r\nConveniently commute to The Woodlands & Downtown Houston w/easy access to I-45. In close proximity to Lake Conroe, restaurants, entertainment, and shopping.','0.2214','19','KB Homes','','Electric Dryer Connections','','No Disclosures,Sellers Disclosure','1','','','Conroe Southwest','Central Electric','1','S336602 - CAYDEN CREEK 02, BLOCK 2, LOT 5','Subdivision Lot','9644','Survey','','595','0','','2','Electric Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','11 - Conroe','RICE ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox','Seller','1','Ranch','Cayden Creek 02','5472','2.8863','Public Sewer,Public Water','2018','Seller'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:41:19.907' ,`MLSNumber` = '49218992' ,`ListAgentFullName` = 'Tod Franklin' ,`ListOfficeName` = 'DFWCityhomes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816100' ,`Longitude` = '-95.561368' ,`PhotoCount` = '41' ,`PostalCode` = '77043' ,`RoomCount` = '10' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Alcott' ,`StreetNumber` = '10650' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2805' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location Location Location! Spacious 5 bedroom home with 2 Primary suites! – Easy access to Beltway 8, I-10 and Hwy. 290. It is very close to City Center, Memorial City mall area, Bear Creek Pioneer Park, Baseball USA, and the Energy Corridor. Upstairs Primary bedroom also has a wall of closets plus a new renovated bathroom with a 5ft wide shower and a stand-alone tub! Recent remodel includes all bathrooms, Double Pane Windows, new kitchen remodel, Water heater, light fixtures, Energy efficient fans, flooring, new AC system, electrical wiring, PEX plumbing, fresh paint and the foundation has been evaluated by a foundation company that said “No repairs are needed”. Perfect Floor-plan for Roommates' ,`Acres` = '0.1791' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 BLK O SPRING BRANCH VALLEY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TERRACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Spring Branch Valley' ,`TaxAmount` = '6797' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665583929' WHERE `Matrix_Unique_ID` = '213261143' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:14:10.100' ,`MLSNumber` = '52543503' ,`ListAgentFullName` = 'Elizabeth Habbitt' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.616481' ,`Longitude` = '-95.457767' ,`PhotoCount` = '27' ,`PostalCode` = '77045' ,`RoomCount` = '12' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Gallagher' ,`StreetNumber` = '5028' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '1380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property has two entry driveways. There are two building on the property along with a storage house. The front of the property is fenced and faces east. The front property has three bedrooms and two full baths.\r\n The back quartesr has two levels with two bedrooms upstairs and two toilets and sinks . The lower level is an open space.. There is a minimum of five bedrooms between the front and back property.' ,`Acres` = '1.5817' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 5-8 DIST:061 CITY/MUNI/TWP: CITY OF HOUSTON LTS 5 6 7 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '68899' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GRISSOM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Tiffany Gardens/' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Well' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583929' WHERE `Matrix_Unique_ID` = '213265880' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:22:00.963' ,`MLSNumber` = '65187096' ,`ListAgentFullName` = 'Stephanie Palmer' ,`ListOfficeName` = 'Leopold & Strahan Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.483989' ,`Longitude` = '-95.090765' ,`PhotoCount` = '25' ,`PostalCode` = '77573' ,`RoomCount` = '8' ,`ListPrice` = '509900.00' ,`Status` = 'Active' ,`StreetName` = 'Torrance' ,`StreetNumber` = '1540' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3929' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home. This beautiful home is a must see. Located in the highly desired neighborhood of Victory Lakes, this 4 bedroom, 3 1/2 bath , 2 story home is just waiting for you. This home features a beautiful brick and stone exterior. Once inside you will find a beautiful palatial entry. Soaring ceiling in the family room with open concept to the beautiful kitchen and a large island, perfect for entertaining family and friends or hosting holiday get togethers. You will find privacy in the large primary bedroom and ensuite bathroom with double vanities, soaking tub, separate shower and large walk-in closet. Upstairs is perfect for game night or a great place to hang out with a huge game room and 3 large bedrooms and 2 bathrooms. Once out back you will find a large fenced backyard and no back neighbors. Come see this beautiful home today!!' ,`Acres` = '0.1893' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'VICTORY LAKES SEC 5 (2007) ABST 3, BLOCK 1, LOT 42, ACRES 0.' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8247' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '715' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double 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` = 'Accompany,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Victory Lakes Sec 5 2007' ,`TaxAmount` = '10557' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583929' WHERE `Matrix_Unique_ID` = '213272444' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:50:02.080' ,`MLSNumber` = '26146564' ,`ListAgentFullName` = 'Jacqueline Booth' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices' ,`SellingAgentFullName` = 'Jacqueline Booth' ,`SellingOfficeName` = 'Berkshire Hathaway HomeServices' ,`Latitude` = '29.297869' ,`Longitude` = '-94.916199' ,`PhotoCount` = '41' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '739000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Coral' ,`StreetNumber` = '1331' ,`StreetSuffix` = 'Way' ,`City` = 'Tiki Island' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look no further, you\'ve found the perfect bay home in this 2/2 with a gorgeous pool and two tiki huts. This home sits on 1 1/2 lots and features a large living area, an open concept kitchen/dining area, and a spacious wrap-around south-facing deck. You will love the pool, hot tub, bar, and large tiki huts with an outdoor kitchen and built-in table. Upgrades done by the owner include concrete bulkhead, Hardie siding (2008), storm-rated windows (2008), roof (2008), roll-down storm shutters, pool with hot tub(2018), sprinkler system, s/s appliances, granite in the kitchen, new A/C approx. (2018), outdoor kitchen & Tiki huts (2018). Furnishings are negotiable. The seller also owns the adjacent lot and would consider selling it with the home. Ask your agent for details.' ,`Acres` = '0.1712' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 SC BUNDICK SUR LOT 36A TIKI ISLAND SEC 6 RPLT' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '7457' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Tiki Island' ,`TaxAmount` = '14191' ,`TaxRate` = '2.4912' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583929' WHERE `Matrix_Unique_ID` = '213295485' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:22:00.963' ,`MLSNumber` = '33180797' ,`ListAgentFullName` = 'Christopher Case' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838744' ,`Longitude` = '-95.478756' ,`PhotoCount` = '33' ,`PostalCode` = '77092' ,`RoomCount` = '3' ,`ListPrice` = '359900.00' ,`Status` = 'Active' ,`StreetName` = 'Hoover' ,`StreetNumber` = '6011' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1481' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! 3 Bedroom / 2 full bath / 2 car garage home located in the sought after neighborhood of Forest Pines. This newly renovated home features nice white kitchen cabinetry and a stove, with sizeable counter space. This beautiful home has luxury vinyl laminate flooring and fresh paint thru-out. A spacious master suite and fully updated bathrooms that include new showers & courtz countertops. Enjoy the large back patio and green space, which is perfect for entertaining. Located minutes to the major roads like Highway 290, 610, and Beltway 8. Excellent location- close to The Galleria, Spring Branch and Memorial Park makes for an easy commute. Move in ready- schedule your showing today!' ,`Acres` = '0.1567' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 17 FOREST PINES SEC 2A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Pines Sec 02a' ,`TaxAmount` = '5652' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583929' WHERE `Matrix_Unique_ID` = '213302918' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:18:36.280' ,`MLSNumber` = '38633348' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.604583' ,`Longitude` = '-95.302267' ,`PhotoCount` = '8' ,`PostalCode` = '77048' ,`RoomCount` = '3' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Dayridge' ,`StreetNumber` = '6826' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1686' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, location, location. Charming two-story home in a premium cul-de-sac lot with a lake view. You walk into an open floor plan with living room and kitchen combo. The kitchen features a granite countertop with all stainless appliances( gas range, microwave, dishwasher). Fully fenced and huge Backyard. The area is super quiet. Move-in ready. Conveniently located with quick access to Sam Houston Tollway.' ,`Acres` = '0.1023' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 2 SOUTHRIDGE CROSSING SEC 5' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '4456' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MITCHELL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southridge Xing' ,`TaxAmount` = '6163' ,`TaxRate` = '3.0707' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583930' WHERE `Matrix_Unique_ID` = '213342085' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T06:56:59.917' ,`MLSNumber` = '78162642' ,`ListAgentFullName` = 'Shane Krantz' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.043657' ,`Longitude` = '-95.613541' ,`PhotoCount` = '44' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '359500.00' ,`Status` = 'Active' ,`StreetName` = 'Papago' ,`StreetNumber` = '19407' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2392' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this one-of-a-kind property in Canyon Gate at Northpointe. This is the largest lot in the neighborhood at 17,500 sq ft. That\'s right almost half of an acre and did I mention it\'s also in a cul-de-sac with easy access to 249 and Grand Parkway? Enjoy your morning coffee in your backyard retreat with the peaceful sounds of the custom water feature on your large covered back porch. Beautiful 2-story brick elevation with lush landscaping. This home is being sold by the original owner and had been meticulously maintained since 1999. The subdivision, Canyon Gate at Northpointe, is just minutes away from Vintage Park, a great area for shopping and fine dining. Community amenities include a clubhouse, pool, fitness room, covered sports court, tennis courts, children’s parks, and walking trail. Zoned to acclaimed Tomball Memorial High School in Tomball ISD. Schedule a showing today!' ,`Acres` = '0.402' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 2 CANYON GATE AT NORTHPOINTE SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '17511' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CANYON POINTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate At Northpointe' ,`TaxAmount` = '7165' ,`TaxRate` = '2.9165' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583930' WHERE `Matrix_Unique_ID` = '213351035' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:26:44.227' ,`MLSNumber` = '63248443' ,`ListAgentFullName` = 'Cindy Bell' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.808633' ,`Longitude` = '-95.527818' ,`PhotoCount` = '16' ,`PostalCode` = '77080' ,`RoomCount` = '9' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Sedgie' ,`StreetNumber` = '2014' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1207' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Selling as is: One story 3 bedroom 2 bath 1 car attached garage home with large back yard in a well established neighborhood. Lots of potential for new owners.Close to shopping, schools and freeways. Roof 5 years old.' ,`Acres` = '0.1646' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 3 CAMPBELL WOODS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7169' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'PINE SHADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Left Side,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Campbell Woods' ,`TaxAmount` = '4190' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583930' WHERE `Matrix_Unique_ID` = '213376848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T06:59:37.927' ,`MLSNumber` = '80908420' ,`ListAgentFullName` = 'Ryan Steer' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809348' ,`Longitude` = '-95.416946' ,`PhotoCount` = '40' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = '26th' ,`StreetNumber` = '1032' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2108' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in the heart of the Heights, you\'ll enjoy the convenience of being close to all that Houston has to offer, while tucked away in a small, welcoming neighborhood of Shady Acres. You’ll enjoy spending time in your well-appointed kitchen that overlooks the living and dining areas on the second floor or relaxing on your private balcony overlooking lush landscaping – complete with an additional guest parking spot. With plenty of storage and an over-sized island, this kitchen is perfect for whipping up your favorite recipe or hosting friends and family for dinner. The third floor features a spacious primary suite along with a generous closet and primary bath to pair. Call us today for more info on the features of this home & to schedule your Virtual or Private Tour!' ,`Acres` = '0.0358' ,`Area` = '9' ,`BuilderName` = 'CitySide Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1 GROVE AT SHADY ACRES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1559' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Grove/Shady Acres' ,`TaxAmount` = '8323' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1665583930' WHERE `Matrix_Unique_ID` = '213379673' --> 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','213413143','1665583930','213413143','2022-10-12T07:51:43.370','23011498','Jody Ricco','Ricco Realty','','','29.494138','-95.713578','32','77469','7','350000.00','Active','Dry Creek','9722','Court','Richmond','2','1','4','2310','Single-Family','This home has a lot of upgrades and a fantastic location. On a cul-de-sac and backing to Dry Creek it has a wrought iron fence along the back with a gate to access the greenspace and enjoy the view. Hardwood floors throughout except the bedrooms. Dramatic entry features tray ceilings. The study off of the extended foyer has double doors. Formal dining room with butlers pantry. The island kitchen is huge and has an extended serving bar, complete with granite countertops, undermount sink and glass tile backsplash. Perfect for entertaining, the kitchen is open to the living. A wood burning fireplace with gas connections is featured in the family room. The plan is open and features lots of windows. The primary bedroom has an executive bath with separate shower, large soaking tub and double sinks. The exterior is fully bricked and has a covered patio in back to enjoy the views of the creek. Privacy fence along side yard. Mature landscaping and inviting entry. Great Neighborhood Amenities!!','0.1611','30','','','','','Mud,Sellers Disclosure','1','','1','Fort Bend South/Richmond','Central Gas','1','BONBROOK PLANTATION SOUTH SEC 5, BLOCK 1, LOT 53','Cul-De-Sac,Greenbelt','7017','Appraisal District','','700','0','','2','','0','','','Gas Range','','Composition','33 - Lamar Consolidated','CARTER ELEMENTARY SCHOOL','GEORGE RANCH HIGH SCHOOL','RYON/READING JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Bonbrook Plantation','7381','2.6948','Water District','2015','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','213423450','1665583930','213423450','2022-10-12T07:43:03.473','37326580','Maria Borbolla','Woodsedge Properties','','','29.501623','-95.540943','50','77459','11','695000.00','Active','Fitzgerald','8511','Way','Missouri City','3','1','4','4239','Single-Family','More than a house, a Home. This particular Home is for you, starting with incredible curb appeal and the grand foyer with beautiful staircase and high ceilings you will appreciate the custom touches. Sellers have invested thousands of dollars in upgrades including French doors in the library; NO CARPET; luxury vinyl floors throughout, plus new light fixtures and hardware. Outstanding WOW factor windows from floor to ceiling afford an enviable view of the pool with new covered patio and outdoor kitchen all on an ultra private greenbelt with no rear neighbors!\r\nThe primary bedroom is incredibly spacious plus the ensuite will make you look for time in your busy schedule to wind down and relax.\r\n New HVACs and Water Heater, generator. More features, schedule a visit to discover your next Home.','0.3053','38','Perry Homes','','Gas Dryer Connections,Washer Connections','','No Disclosures','','','','Sienna Area','Central Gas,Zoned','1','SIENNA STEEP BANK VILLAGE SEC 5-B, BLOCK 1, LOT 10','Greenbelt,In Golf Course Community,Subdivision Lot','13300','Appraisal District','','1500','0','','3','Double Oven','1','Gunite,Heated','','Gas Cooktop','','Composition','19 - Fort Bend','SIENNA CROSSING ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','BAINES MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Sienna Steep Bank Village Sec 5-B','10808','2.5729','Public Sewer,Public Water,Water District','2004','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:36:54.990' ,`MLSNumber` = '89503860' ,`ListAgentFullName` = 'Gary Swafford' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.932641' ,`Longitude` = '-95.671425' ,`PhotoCount` = '47' ,`PostalCode` = '77095' ,`RoomCount` = '11' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Sonoma Del Norte' ,`StreetNumber` = '16730' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3856' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully Updated 5 bedroom 3.5 bath home ON GOLF COURSE in Stone Gate. Some Features include; New Carpet and LVP Flooring, Porcelain tile w/Matte Finish in Baths, New Interior & Exterior Paint, Ceiling Fans, Recessed Lighting, Private study w/French Doors, Formal Dining with Built in Shelving, Large Open Island White kitchen w/Quartz counters, SS App, Spacious Open Family Room w/Fireplace, Downstairs Primary Retreat & Spa Like Bathroom w/Oversized, Seamless Shower, Quartz Counters + New Fixtures & Finishes, Wrought Iron Balusters, Upstairs Gameroom + 4 oversized bedrms + 2 Full Bathrms + Large Balcony overlooking the tranquil backyard & Golf Course, Ample Closet & Storage Space throughout, Zoned A/C systems, Sprinkler System, Oversized Covered Patio overlooks the peaceful backyard w/plenty of room to entertain, garden or run & play, New Roof (6/22), Plus Much More! Zoned to Highly Acclaimed CFISD Schools! Close to Grocery, Retail, Restaurants, Entertainment, 290, Beltway 8 & 99!' ,`Acres` = '' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 40 BLK 2 STONE GATE SEC 3' ,`LotDesciption` = 'On Golf Course,Subdivision Lot' ,`LotSize` = '8463' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Gate' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583930' WHERE `Matrix_Unique_ID` = '213425136' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T06:35:23.213' ,`MLSNumber` = '9383954' ,`ListAgentFullName` = 'Noreen Arleth' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.222911' ,`Longitude` = '-95.802694' ,`PhotoCount` = '36' ,`PostalCode` = '77355' ,`RoomCount` = '7' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Encinal' ,`StreetNumber` = '18729' ,`StreetSuffix` = 'Trail' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2084' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lightly lived in 4 bedroom home in popular subdivision in Magnolia ISD. Property sits on a large lot on a cul-d-sac street and near the back of the subdivision, so it\'s a low-traffic area. Open floor plan with granite island and breakfast bar separating kitchen from den. Split bedroom plan with primary bedroom and bath off by itself. Primary bath has dual sinks, separate shower and soaking tub. Covered back porch on oversized lot with privacy fence. This is a beautiful home, very well taken care of. Ranch Crest is convenient to the new HEB opening in November, 249 Extension taking you to Tomball or Hwy 105 in minutes, Magnolia West High School and Williams Elementary. No MUD taxes and low HOA!' ,`Acres` = '0.2909' ,`Area` = '15' ,`BuilderName` = 'LGI' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S821104 - RANCH CREST 04, BLOCK 2, LOT 53' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '12671' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ranch Crest' ,`TaxAmount` = '4295' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583931' WHERE `Matrix_Unique_ID` = '213446674' --> 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','213458613','1665583931','213458613','2022-10-12T07:44:57.290','64177090','Dawei Ke','Glad Realty LLC','','','29.968580','-95.176711','50','77346','10','549000.00','Active','Mount Riga','17315','Drive','Humble','3','1','5','3645','Single-Family','Beautiful 2- story home located in the Grove community. Features 5 bedrooms (2 downstairs), 3 full bathrooms, 1 half bathroom, an office, a big game room, and a covered patio in the backyard. Wood flooring, a large open kitchen with granite countertops, and a butler\'s pantry. Upgraded window shutters, fresh new paint, newly replaced AC coil, and brand NEW stove. Close to Beltway 8, and tons of amenities.','0.2396','1','','','Electric Dryer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Summerwood/Lakeshore','Central Gas','1','LT 16 BLK 2 GROVES SEC 4','Corner,Subdivision Lot','10439','Appraisal District','','282','0','','3','Electric Oven,Single Oven','0','','','Gas Range','','Composition','29 - Humble','GROVES ELEMENTARY SCHOOL','ATASCOCITA HIGH SCHOOL','WEST LAKE MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','The Groves','13915','3.443','Public Sewer,Public Water','2016','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T06:41:48.170' ,`MLSNumber` = '8726620' ,`ListAgentFullName` = 'Silvana Trejos' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.648588' ,`Longitude` = '-95.369053' ,`PhotoCount` = '15' ,`PostalCode` = '77051' ,`RoomCount` = '3' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Corksie' ,`StreetNumber` = '3629' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1150' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and newly remodeled 3 bedroom 1 bath home located in Scottcrest neighborhood! Large backyard, No HOA, and conveniently access to Highway 288, 610 and Beltway 8. Only minutes from Downtown and the Medical Center.' ,`Acres` = '0.1466' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 19A & 20B W 25.2 FT OF LT 19 & E 32.6 FT OF LT 20 BLK 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6388' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Scottcrest' ,`TaxAmount` = '1658' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583931' WHERE `Matrix_Unique_ID` = '213459962' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:56:22.857' ,`MLSNumber` = '59214283' ,`ListAgentFullName` = 'Karen Davis' ,`ListOfficeName` = 'KLD Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.682055' ,`Longitude` = '-95.939737' ,`PhotoCount` = '47' ,`PostalCode` = '77441' ,`RoomCount` = '11' ,`ListPrice` = '697000.00' ,`Status` = 'Active' ,`StreetName` = 'Westerdale' ,`StreetNumber` = '5618' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4118' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE REDUCED from $725,000.\r\nLocated on a gorgeous 1/2-Acre lot with century old Pecan trees, this superbly crafted 2-Story blends with the natural setting with a mix of stucco, stone, brick, and metal accent roofs. Inside find travertine, granites, marble, wrought iron, custom cabinetry, crown molding, 5-inch baseboards, built-in speakers & warm designer paint colors. Majestic stone Fireplace, high ceiling, and built-in cabinetry in Family Room. Island Kitchen with granite countertops and Breakfast Bar. Breakfast Room overlooking the backyard. Huge Primary Suite with raised ceiling. 2nd Bedroom down. Game Room and 3-large Bedrooms up. \r\nThis home is in the Golf Course community of Weston Lakes tucked behind a 24-hour manned gate. Offering a casual Country Club, Waterside Grill, 18-hole Golf Course, workout facility, 2 pools, 2 tennis courts, 4 pickleball courts, natural lakes, river, and area parks. The neighborhood is zoned to exemplary schools and has Low tax rates.' ,`Acres` = '0.4902' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTON LAKES SEC 2, BLOCK 4, LOT 20' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '21353' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Weston Lakes' ,`TaxAmount` = '9792' ,`TaxRate` = '2.1698' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583931' WHERE `Matrix_Unique_ID` = '213472282' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:51:37.300' ,`MLSNumber` = '18753975' ,`ListAgentFullName` = 'Zachary Davies' ,`ListOfficeName` = 'The Cox Company Real Estate Gr' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.819615' ,`Longitude` = '-95.121203' ,`PhotoCount` = '17' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '194900.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 356' ,`StreetNumber` = '748' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1096' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom, 2 bath home is tucked away right off of 356. With a fully fenced in yard, concrete circle drive, a big front porch with wheelchair access, you can find this is the perfect home for you.' ,`Acres` = '0.1928' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON PARK SECTION 2 LOT 8' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '126' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Park Sec 2' ,`TaxAmount` = '2192' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583931' WHERE `Matrix_Unique_ID` = '213493296' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T06:52:58.883' ,`MLSNumber` = '87679762' ,`ListAgentFullName` = 'Meriam Shaw' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813065' ,`Longitude` = '-95.766685' ,`PhotoCount` = '44' ,`PostalCode` = '77449' ,`RoomCount` = '9' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Brafferton' ,`StreetNumber` = '22726' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2225' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You must see this fully renovated 2,225sqft 4 bed 3 1/2 bath including a 200sqft In-Law Suite featuring a walk-in closet & a bathroom located on the 1st floor! EXTERIOR UPDATES New Roof, New Vinyl Windows, Hardie Plank Siding, Paint, Exterior Doors, Gutters, Insulation, Lighting, Landscaping, New Sod, Fencing, & Mailbox with lock! INTERIOR UPDATES New Flooring throughout the home, Baseboards, Light fixtures, Interior Paint, Recess Lighting, Solid Interior Doors & Hardware, Ceiling Fans, Custom Cabinets w/ self closing drawers, Granite & Quartz Countertops, New Stainless Steel Appliances, New Pex Piping, &Hot Water Heater, New Fuse Box & relocated to the garage, brand new garage opener w/ keyless pad, New A/C, all bathrooms renovated! The BACKYARD features 15x15 Covered Patio& an Outdoor Kitchen w/ stainless steel premium grill along w/ sink, brick fireplace,& new drainage with drain boxes.*Seller has an active surveillance system everyone will be recorded when they enter the property*' ,`Acres` = '0.1529' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 29 WILLIAMSBURG COLONY SEC 4' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6660' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '420' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WINBORN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MORTON RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Williamsburg Colony' ,`TaxAmount` = '3500' ,`TaxRate` = '2.4333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583931' WHERE `Matrix_Unique_ID` = '213497967' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T06:01:08.933' ,`MLSNumber` = '52977843' ,`ListAgentFullName` = 'Martha Rosario' ,`ListOfficeName` = 'CJM Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.526932' ,`Longitude` = '-95.176814' ,`PhotoCount` = '24' ,`PostalCode` = '77546' ,`RoomCount` = '4' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Bend' ,`StreetNumber` = '16727' ,`StreetSuffix` = 'Avenue' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this beautiful home, great for first time home buyer! Home has been fully remodeled from top to bottom and is looking for its new owner! Please reach out today to set up a showing!' ,`Acres` = '0.1515' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 23 BLK 15 FOREST BEND SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WEDGEWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Bend Sec 02' ,`TaxAmount` = '4102' ,`TaxRate` = '2.2534' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583932' WHERE `Matrix_Unique_ID` = '213503582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:08:50.443' ,`MLSNumber` = '96093394' ,`ListAgentFullName` = 'Dat Trinh' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.167392' ,`Longitude` = '-95.775400' ,`PhotoCount` = '45' ,`PostalCode` = '77355' ,`RoomCount` = '9' ,`ListPrice` = '975000.00' ,`Status` = 'Active' ,`StreetName` = 'Sapphire' ,`StreetNumber` = '28710' ,`StreetSuffix` = 'Circle' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '3901' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic property that is renovated and updated inside and out that is nestled in the quiet, peaceful Indigo Lakes Estates subdivision. The 3901 sq. ft one and a half story sits on a tad over 4 acres and features tall ceilings, 6 bedrooms, a study, a sunroom, recently updated A/C, recent roof, recently replaced water heaters, 5 burner gas cooktop, double ovens, huge open living room with connecting dining room and centrally located fireplace that can use gas or burn logs, stand up showers in 3 of the 4 1/2 and half baths, travertine and wood floors, new carpet in the game room upstairs, updated fans and light fixtures, and new deck in the backyard.' ,`Acres` = '4.085' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'INDIGO LAKE ESTATES 04, BLOCK 2, LOT 8, 9' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '177943' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Colonial,Other Style' ,`Subdivision` = 'Indigo Lake Estates 04' ,`TaxAmount` = '10550' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Water,Septic Tank,Well' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583932' WHERE `Matrix_Unique_ID` = '213525374' --> 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','213525995','1665583932','213525995','2022-10-12T06:57:44.720','13767615','David Herzog','Texas Ally Real Estate Group,','','','29.822939','-95.426266','49','77018','4','1475000.00','Active','Fisher','1029','Street','Houston','3','1','4','4091','Single-Family','','0.1612','9','Herzog Homes','','','','Other Disclosures','1','','2','Oak Forest East Area','Central Gas','0','LT 3 BLK 16 OAK FOREST SEC 1','Other','7020','Survey','','','0','','2','','1','In Ground','','','','Composition','27 - Houston','GARDEN OAKS ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required','Builder','2','Contemporary/Modern','Oak Forest Sec 01','25529','2.3307','Public Sewer,Public Water','2019','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:58:25.253' ,`MLSNumber` = '58611847' ,`ListAgentFullName` = 'Christina Conn' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768104' ,`Longitude` = '-95.768557' ,`PhotoCount` = '42' ,`PostalCode` = '77450' ,`RoomCount` = '7' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Cascade Creek' ,`StreetNumber` = '1111' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2033' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTORS ONLY. BEING SOLD WITH ONE YEAR LEASE IN PLACE. Fabulous affordable 4 bedroom/ 2.5 bath rental in popular Cimarron subdivision in South Katy! Detached oversized garage and huge back yard with extended patio. Covered porch entryway and mature landscaping. \r\nNicely updated. Fresh paint and recent flooring. No carpet. Roomy primary suite with huge closet and 3 spacious guest rooms. Upgraded kitchen. Huge family room with fireplace. Formal dining room and breakfast nook. \r\nThis home has it all and a short walk to the award winning Cimarron Elementary. Highly ranked KISD. Community pool and tennis court. No flooding. \r\nClose to shopping and retail. Easy access to 1-10, 99 and 1093.' ,`Acres` = '0.169' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 40 CIMARRON SEC 9 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Cimarron Sec 09 Pt Rep' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583932' WHERE `Matrix_Unique_ID` = '213528576' --> 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','213529260','1665583932','213529260','2022-10-12T07:42:40.700','97087093','Holly Rosser','RE/MAX Integrity','','','30.189299','-95.781498','34','77355','6','415000.00','Active','Todd','19260','Road','Magnolia','2','0','3','1400','Single-Family','RARE OPPORTUNITY! UNRESTRICTED - PRIVATE OR PROFITABLE - 3.5 ACRES Right off of FM 1488 in Magnolia! Home sits on Slab w/Builders Pier w/Insulated Stucco Skirting, LG 40x30 WORKSHOP on Slab(Wired w/Electric & 240 Outlet), 50 AMP RV HOOKUP Behind Workshop! Meticulously Maintained Home & Acreage & Partially Wooded for Privacy, Recently Replaced HVAC & Water Heater, HUGE Kitchen w/New SS Appliances, New Laminate Wood Flooring Throughout, DOUBLE PANE WINDOWS THROUGHOUT. Upgraded Fixtures on All Sinks & Added Shut-Off Valves, Freshly Painted Interior, New Toilets, Split Plan w/Primary Suite w/Corner Soaking Tub & Sep. Shower, Dual Sinks & LG. Walk in Closet. Roomy Secondary Bedrooms w/Walk in Closets, Upgraded Back Door 2022, HUGE Front Covered Patio w/Ceiling Fan & Covered Side Patio, Upgraded Ceiling Fans in all Rooms, Crown Molding & 2 In. Blinds Throughout, Laundry Room in House, Fresh Landscaping, LOW TAXES-NO HOA, Excellent Location in the Growing Magnolia Area & Acclaimed ISD!','3.5','15','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Magnolia/1488 West','Central Electric','0','A0709 - LEE E N JR, TRACT 1 LOT 1-B IMP ONLY, SERIAL # DMH19','Cleared,Wooded','152460','Appraisal District','','','0','','4','Electric Oven,Single Oven','0','','','Electric Range','','Composition','36 - Magnolia','WILLIE E. WILLIAMS ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Ranch','Alford Estates','444','1.8587','Aerobic,Septic Tank,Well','2005','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','213537098','1665583932','213537098','2022-10-12T07:17:29.650','77782950','Emiliano Lupi','Keller Williams Metropolitan','','','29.657143','-95.453394','6','77035','6','349990.00','Active','Benning','4522','Drive','Houston','2','0','3','1977','Single-Family','Absolute bargain, an unbelievable price! This is your chance to get a great deal on a 2019 remodeled single-story home in Willow Meadows Area. Fantastic three bedrooms and two baths. Open concept with perfect dimension and shape. Large primary bedroom with en-suite bathroom: double sinks in bath, shower, jetted tub, and huge walking closet. Built-in stainless steel electric oven and microwave (Frigidaire). Gas cooktop and quartz countertops. Modern white soft close cabinetry and drawers.\r\nExcellent location, very close to 610. Minutes from Medical Center, Galleria, Rise University, NRG Stadium. Make an appointment to see it soon - it won\'t last long!','0.1582','20','','','Washer Connections','','Sellers Disclosure','1','','','Willow Meadows Area','Central Gas','0','LT 21 BLK 5 POST OAK MANOR SEC 2','Subdivision Lot','6893','Appraisal District','','','0','','1','Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','RED ELEMENTARY SCHOOL','WESTBURY HIGH SCHOOL','MEYERLAND MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Post Oak Manor Sec 02','7507','2.3307','Public Sewer,Public Water','1955','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','213537841','1665583932','213537841','2022-10-12T07:44:52.720','14944752','Tracy Murski','Southern Realty Group','','','29.780516','-95.634628','38','77079','10','449000.00','Active','Steamboat','15706','Lane','Houston','2','1','3','2644','Single-Family','Nestled in the highly desirable Barkers Landing community sits this beautifully updated & well maintained home. Located in the Energy Corridor & situated on a corner lot-this pristine home has it all! Chef\'s delight kitchen with granite countertops, gas range, Bosch convection wall oven, storage galore, custom cabinetry, designer finishes, tile flooring & SS appliances. Breakfast room off the kitchen leads to the cozy patio & lush backyard. Dining room with soaring ceiling, spacious & serene living room with gas log fireplace, covered patio through French doors & hand scraped hardwood flooring. Huge primary retreat with large ensuite bathroom-2 closets, large vanity, tons of storage, jetted tub & separate shower. Zoned A/C*no carpet*HardiPlank*double pane windows*large backyard French drains recessed lighting & so much more! 24/7 security patrol*pool*park*tennis courts. Close to Terry Hershey Park, restaurants, shopping & med centers. Did not flood. Zoned to Katy ISD.','0.1318','23','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace,Wood Burning Fireplace','1','Energy Corridor','Central Gas','1','LT 7 BLK 2 BARKERS LANDING SEC 1','Corner,Patio Lot,Subdivision Lot,Wooded','5743','Appraisal District','','1045','0','','2','Convection Oven,Double Oven,Electric Oven','0','','','Gas Range','','Composition','30 - Katy','WOLFE ELEMENTARY SCHOOL','TAYLOR HIGH SCHOOL (KATY)','MEMORIAL PARKWAY JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Barkers Landing Sec 01','7576','2.4889','Public Sewer,Public Water','1978','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213541619','1665583932','213541619','2022-10-12T06:57:01.133','20497784','Becky Ellis','A.M. Real Estate','','','29.790352','-95.529490','25','77055','7','549000.00','Active','PINE LAKE','9706','Drive','Houston','2','0','3','2047','Single-Family','HomePath offers you this Designer influenced remodeled home in Spring Branch!Walk up to the charming front porch with its cedar columns,designer tile & inviting upgrade front door.When you step into this home,you are greeted by real hardwood floors that have been beautifully refinished throughout the home.This home has entertaining flow from the living rm to dining & den.The dining has it\'s own serving bar.The grand den has a mega dining bar,deco fireplace with gas logs & a wall of windows overlooking the backyd,patio & the sparkling POOL.The kitchen has a view of the den & dining rm with NEW quartz counters,herringbone backsplash,stylish lighting,Shaker style soft close drawers & cabinets & new APPLIANCES! Bedrms are ample size with new fans & wood or tile floors.Both baths are delightful with NEW vanities,quartz counters,lighting,faucets & designer diagonal flooring.The primary bath has dual sinks & a mega linen closet. There is a cute workshp/storage/poolhouse in the massive backyd.','0.1901','24','','','Electric Dryer Connections,Washer Connections','','No Disclosures,Real Estate Owned,Special Addendum','1','Gas Connections,Gaslog Fireplace','1','Spring Branch','Central Gas','0','LT 13 BLK 18 LONG POINT WOODS SEC 3','Subdivision Lot','8280','Appraisal District','','','0','','0','Electric Oven','1','In Ground','','Electric Cooktop','','Composition','49 - Spring Branch','WOODVIEW ELEMENTARY SCHOOL','SPRING WOODS HIGH SCHOOL','SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)','Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal District','1','Ranch','Long Point Woods Sec 03','13382','2.4415','Public Sewer,Public Water','1960','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','213557209','1665583932','213557209','2022-10-12T06:51:47.763','7257099','Kerri Canales','316 Realty Group','','','30.072408','-95.406509','8','77373','4','260000.00','Active','Foxbriar','25507','Lane','Spring','2','0','3','1868','Single-Family','This beautiful home has been well cared for over the years and has many upgrades. The roof was replaced in 2017, new A/C in 2020, all windows replaced with energy efficient double pane windows, gutters installed, and kitchen remodeled. Kitchen remodel includes new cabinets with quartz countertops, and new appliances including gas line installed for gas cooktop. The bathrooms have been remodeled and house was freshly painted in 2020. Laundry room is in the house. This beautiful home has all the amenities of city living tuck away in a quiet neighborhood. Pack your bags this house is a move in ready!','0.2101','12','','','','','Sellers Disclosure','','Freestanding','1','Spring East','Central Electric','1','LT 34 BLK 5 LEXINGTON WOODS SEC 1','Cul-De-Sac','9150','Appraisal District','','395','0','','1','','0','','','','','Composition','48 - Spring','JOHN WINSHIP ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','TWIN CREEKS MIDDLE SCHOOL','Supra Keybox','Appraisal','1','Traditional','Lexington Woods Sec 01','3438','2.2769','Public Sewer,Public Water','1972','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T07:34:56.150' ,`MLSNumber` = '88838370' ,`ListAgentFullName` = 'Christy Luong' ,`ListOfficeName` = 'Precious Realty & Mortgage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.901462' ,`Longitude` = '-95.666121' ,`PhotoCount` = '33' ,`PostalCode` = '77095' ,`RoomCount` = '9' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Innisbrook' ,`StreetNumber` = '16702' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is beautiful FORMAER MODEL house located in the gated Brookside Court subdivision of Copperfield area features 4 bedrooms, 2.5 bath 2 car garage, LARGE island kitchen with upgraded granite countertop & title backsplash, large family room with corner fireplace/mantle. All bedrooms are upstairs, great master bedroom with large master bath with walk-in closet, his and her vanity tub and separate shower. There are well size secondary bedroom and along long with hug game room. This home offered soaring high ceiling, open concept, large window and tons of natural light. This home RECENTLY REMODEL in 2021. High rated Cypress Fairbanks ISD schools and conveniently located close to HWY 290. 99 Grand Parkway, Beltway 8, Dinning, Shopping, Outlet Mall and Entertaiment. Home has never flooded. A MUST SEE!!!!' ,`Acres` = '0.137' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 2 BROOKSIDE COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5968' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '737' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BIRKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookside Court' ,`TaxAmount` = '7311' ,`TaxRate` = '2.881' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583932' WHERE `Matrix_Unique_ID` = '213561952' --> 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','213568421','1665583933','213568421','2022-10-12T07:17:45.877','79152838','Bruce Brittimes','Brittimes Realty','','','29.901326','-95.245093','16','77050','4','2000000.00','Active','Forest Acres','13525','Drive','Houston','3','1','4','3265','Single-Family','Location, Location, Location within seconds of Generation Park Community, closes to George Bush Intercontinental Airport and minutes of Downtown Houston. Unrestricted 12.57ac with 3200plus square foot home. This property would be ideal for Land Developers or someone wanting agriculture exemption. Land has a fully stocked pond and livestock freely environment.','3.5669','1','','','','','Sellers Disclosure','','','','Northside','Central Gas','0','TR 24A FOREST ACRES','Cleared,Corner,Water View,Waterfront,Wooded','155375','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','MARSHALL ELEMENTARY SCHOOL','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Contemporary/Modern','Forest Acres','883','1.8999','Public Sewer,Public Water','1980','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','213568528','1665583933','213568528','2022-10-12T06:52:14.283','10055917','Ivannia Recio','Ace Realty','','','29.544172','-95.033403','50','77565','4','330000.00','Active','Oak','711','Road','Kemah','2','0','1','1170','Single-Family','BEAUTIFUL UPDATED HOME IN HISTORIC CLEAR LAKE SHORES-Main living area on the second level has 1 bedroom, with hardwood floors, and fresh new interior and exterior paint. Enjoy evening breezes on your deck as the home is just steps from the water! The lower level is approx. 280 square feet with a full bath, large living area, and granite countertop with a bar and sink ready to use as a game room or guest room. Enjoy The Boardwalk, restaurants, shopping, or a beautiful sunset with neighbors all on your golf cart!','0.1377','33','','','','','Sellers Disclosure','','','','League City','Central Electric','0','ABST 18 M MULDOON SUR LOTS 373,374 & 375 CLEAR LAKE SHORES','Subdivision Lot','6000','Appraisal District','','','0','','0','','0','','','','','Composition','9 - Clear Creek','STEWART ELEMENTARY SCHOOL (CLEAR CREEK)','CLEAR FALLS HIGH SCHOOL','BAYSIDE INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Seller','1','Traditional','Clear Lake Shores','4381','1.8341','Public Sewer,Public Water,Water District','1973','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','213568792','1665583933','213568792','2022-10-12T07:05:06.930','52022146','Alma Puerto','Texas Fast Realty','','','30.361641','-95.624396','12','77316','3','179900.00','Active','Westchase','402','','Montgomery','2','0','3','1043','Single-Family','CASA NUEVA DE DUEÑO A DUEÑO. BAJA CUOTA INICIAL. LLAMAR PARA MAS INFORMACION. OWNER OFFERING ALTERNATIVE FLEXIBLE OWNERSHIP OPORTUNITIES. EASY TO QUALIFY. BUY THIS NEW HOME BEFORE IS GONE ! CALL FOR MORE INFO','0.0482','39','Baranda Group','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Lake Conroe Area','Central Electric','0','LAKE CONROE VILLAGE, BLOCK 19, LOT 4','Other','2100','Appraisal District','','','1','Never Lived In','0','','0','','','Freestanding Range','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Lake Conroe Village','146','1.825','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213569096','1665583933','213569096','2022-10-12T07:40:39.253','75487623','Kristin McAlister','Entera Realty LLC','','','29.887471','-95.667444','0','77095','3','284900.00','Active','Dogwood Falls','7318','Road','Houston','2','0','3','1976','Single-Family','This home will not disappoint. Nestled in a quiet cul-de-sac, this home has it all. The open concept kitchen and ample living room with soaring ceilings are perfect for entertaining. In the back yard, you will find plenty of green space and is complete with a sizable covered patio ( 2021), pool and spa (built 2016). There is a dedicated office/ playroom and a formal dining room. The kitchen features SS appliances, recessed lighting and quartz countertops. The garage has been finished and is currently used as a Gameroom. It has an A/C and heat- but the door is still functional- s it is your choice how you use it! The interior was painted 2020, ceilings were also scraped and painted then too. NO CARPET!! Roof replaced 2016. Never flooded.','0.1956','8','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','','','1','Copperfield Area','Central Gas','1','LT 44 BLK 1 COPPERFIELD SOUTHCREEK VILLAGE SEC 8','Cul-De-Sac,Subdivision Lot','8520','Appraisal District','','695','0','','1','','1','In Ground','','Gas Range','','Composition','13 - Cypress-Fairbanks','LOWERY ELEMENTARY SCHOOL','LANGHAM CREEK HIGH SCHOOL','ARAGON MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','Copperfield Southcreek Village','5403','2.537','Water District','1989','Appraisal District'); --> New record created successfully