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-04T23:00:31.487' ,`MLSNumber` = '75082031' ,`ListAgentFullName` = 'Laura Sweeney' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733796' ,`Longitude` = '-95.452078' ,`PhotoCount` = '45' ,`PostalCode` = '77027' ,`RoomCount` = '12' ,`ListPrice` = '3750000.00' ,`Status` = 'Active' ,`StreetName` = 'Staunton' ,`StreetNumber` = '4511' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '7524' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Old World European elegance meets distinctive modern design in this remarkable residence timelessly crafted by Southampton Homes in a chic central Afton Oaks location. A distinguished Robert Dame design offers impeccable scale and resort-style amenities enhanced by stylish selections with reclaimed materials sourced from around the world. Sumptuous Primary Suite up with private terrace, luxurious bath, and designated dressing rooms. Third Level Game Room and Bedroom #5 share access to a sizable wrap-around terrace surrounded by majestic oaks offering treetop views of the sublime setting. Loggia with outdoor fireplace, summer kitchen, and cabana bath overlooks a serene swimming pool/spa with retractable cover. Elevator capable. Three-car attached Garage.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'Southampton Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Royden Oaks/Afton Oaks' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 & TR 45A BLK 4 AFTON OAKS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,French,Other Style' ,`Subdivision` = 'Afton Oaks' ,`TaxAmount` = '65431' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973204' WHERE `Matrix_Unique_ID` = '205780275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:45:03.920' ,`MLSNumber` = '8353285' ,`ListAgentFullName` = 'Helen Pac Franco' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780575' ,`Longitude` = '-95.429712' ,`PhotoCount` = '45' ,`PostalCode` = '77007' ,`RoomCount` = '4' ,`ListPrice` = '569500.00' ,`Status` = 'Active' ,`StreetName` = 'Petty' ,`StreetNumber` = '5934' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2345' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Modern Architecture located in the desirable Cottage Grove Area. This Lovely, free-standing unit is almost Ready. It has 3 bedrooms, 3.5 baths. This home features an amazing kitchen with a large island bar, quartz countertops, Stainless Steel Appliances, and a gas range. 10 Foot Ceilings on every level, Primary Bath with dual vanities, walking shower, and spa-like tub. Engineered Wood Floors, Double-Pane Sound Proof Windows, High Efficient Trane HVAC and a Large Roof-Top Terrace. NO HOA. House will ready Oct 8th. \r\nThis home is conveniently located close to the Houston coolest Shops, Patio Cafés, Art Galleries, Trendy Eatery Places. Easy access to I-10. Five miles approx. away from Northwest of Downtown Houston, Three miles approx. away from the Galleria Area and River Oaks. Don\'t miss out!' ,`Acres` = '0.0339' ,`Area` = '9' ,`BuilderName` = 'Clariss Group LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cottage Grove' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 TOWNHOMES AT PETTY STREET' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Townhomes/Petty Street' ,`TaxAmount` = '1822' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664973204' WHERE `Matrix_Unique_ID` = '207517323' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:04:20.737' ,`MLSNumber` = '41170485' ,`ListAgentFullName` = 'Ginger Gayden' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835165' ,`Longitude` = '-95.852357' ,`PhotoCount` = '20' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '371400.00' ,`Status` = 'Active' ,`StreetName` = 'Camino Bay' ,`StreetNumber` = '400' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2335' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This open concept home sits in a cul-de-sac lot. This floor plan has a first floor primary suite, tile flooring in Foyer, Living Room, Dining and Kitchen, all Bathrooms, and the Utility Room. Since 1991 Adams homes believes \"The Good life DESERVES a GREAT Home!\" This home has granite countertops, Stainless Steel appliances, brushed nickel finishes, 5 1/4\" baseboards, FULLY SODDED yards, front gutters, blinds, 4 sides brick, and more!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Adams Homes, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNTERRA SECTION 4, LOT 8, BLOCK 2' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664973204' WHERE `Matrix_Unique_ID` = '207775520' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:11:31.417' ,`MLSNumber` = '64583192' ,`ListAgentFullName` = 'Anastasia Gaido' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.288117' ,`Longitude` = '-94.849388' ,`PhotoCount` = '31' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '749900.00' ,`Status` = 'Active' ,`StreetName` = 'Palm Cove' ,`StreetNumber` = '1002' ,`StreetSuffix` = 'Court' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3669' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Picture yourself living in a place where life is relaxed, and good things come easy. A place with character, Mediterranean charm, and minutes away from the Beach and the Bay. Picture yourself at 1002 Palm Cove Court in Galveston, TX. This bay-view beauty features 4 bedrooms, 3.5 bathrooms and multiple balconies to enjoy the outdoors and the beautiful views of the Offatts Bayou & Moody Gardens. Enter the home through the grand entrance with tall ceilings, beautiful crown molding & woodwork. A stellar gourmet kitchen features professional grade VIKING appliances, a 6-burner gas cooktop, a warming drawer, wine refrigerator, built-in convection oven and microwave. Sound system throughout, Video Security System, Elevator to all levels, are some of the highlights. Direct access to I-45, & short distance to NUMBER 13, Sea Star Base Galveston & Pelican Landing Marina- one of the finest full-service marina you will find on the Gulf. Schedule your tour today!' ,`Acres` = '0.1565' ,`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` = 'Teichman/Channelview Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 8 PALM COVE SUB (2002)' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View' ,`LotSize` = '6819' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Palm Cove Sub 2002' ,`TaxAmount` = '13564' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973204' WHERE `Matrix_Unique_ID` = '208446666' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:36:03.963' ,`MLSNumber` = '58843919' ,`ListAgentFullName` = 'Mike Mahlstedt' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Michelle Reyna' ,`SellingOfficeName` = 'The Reyna Realty Group' ,`Latitude` = '29.768798' ,`Longitude` = '-95.419544' ,`PhotoCount` = '23' ,`PostalCode` = '77007' ,`RoomCount` = '7' ,`ListPrice` = '550000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Rose' ,`StreetNumber` = '5705' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2481' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 5705 Rose, a stunning three-story home in the heart of the highly sought after Rice Military. This spectacular residence features an exceptional exterior of sleek stucco, and showcases a private gated front patio with access to the front door. The interior highlights a splendid second floor open-concept living with abundant natural light. Third floor primary suite offers a great space to retreat to with ample room for a sitting area & stunning oversized windows. The beautiful spa-like bath features a luxurious tub & dual amenities. The top level was designed for the utmost convenience and features a utility room, and home office attached to the primary bedroom. Secondary bedrooms with en-suite baths reside on the first and second floors. Just minutes from Houston’s best nightlife, Memorial Park, & so much more!' ,`Acres` = '0.035' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 1 PARK VILLAS AT ROSE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1525' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'PARK VILLAS AT ROSE' ,`TaxAmount` = '12229' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973204' WHERE `Matrix_Unique_ID` = '208833215' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:10:32.900' ,`MLSNumber` = '11660101' ,`ListAgentFullName` = 'Anastasia Gaido' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.283707' ,`Longitude` = '-94.863829' ,`PhotoCount` = '36' ,`PostalCode` = '77554' ,`RoomCount` = '9' ,`ListPrice` = '879900.00' ,`Status` = 'Active' ,`StreetName` = 'Lillian' ,`StreetNumber` = '1007' ,`StreetSuffix` = 'Lane' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3332' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Offered Fully Furnished! Live the quintessential carefree Galveston lifestyle at this recently remodeled Victorian Style Home located in exclusive \"Old Galveston Villas\" waterfront community.The four-bedroom, three and a half bath residence features two Bay View Balconies and a coveted ground-floor setting with a spacious patio that’s perfect for entertaining. An open-style floorplan with a fireplace-warmed living room - a dining room combo, and a fully remodeled kitchen with fresh painted cabinetry, commercial grade stainless steel appliances, a pantry, granite countertops & designer tile. The primary suite includes a sitting area an ensuite bathroom with double vanities, shower, and a free-standing tub overlooking the Offats Bayou. The community pool is shared by the 7 residential homes located inside of this amazing gated community.' ,`Acres` = '0.1272' ,`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` = 'Teichman/Channelview Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 10 OLD GALVESTON VILLAS REPLAT' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '5539' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'Old Galveston Villas Rep' ,`TaxAmount` = '10577' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973204' WHERE `Matrix_Unique_ID` = '209078449' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T23:03:04.130' ,`MLSNumber` = '15577366' ,`ListAgentFullName` = 'Nona Homonko' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.180542' ,`Longitude` = '-95.591932' ,`PhotoCount` = '16' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '498800.00' ,`Status` = 'Active' ,`StreetName` = 'Black Swan Place' ,`StreetNumber` = '166' ,`StreetSuffix` = '' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2209' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful house in an absolute wonderful location & in great condition. Ready to move in. Beautiful neighborhood, quite neighbors, granite counter top, never flooded. The house is in high elevation, high and dry. Within close distance for all the convenient, the Country Clubs just around the corner, Golf Courses, all the shops, Banks, within a short distance away. Not to mention an exemplary schools around the area, along with Excellent Private Schools. \r\nLocated about 18 minutes to Hughes Landing, Lake Woodlands for kayaking, dining at the Woodlands water way. Easy to clean flooring, nice patio to enjoy outdoor alfresco, sprinkler system front and back, backing on to greenbelt, privacy back yard. ExxonMobil campus /HPE Headquarter within 20 minutes away. It\'s a great buy, there is one thing about buying a house that we all should know, finding a well sought after \"LOCATION\". This is it !!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S969997-WDLNDS VIL STERLING RIDGE 97, BLOCK 1, LOT 13' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '6627' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlands Village Sterling Ridge' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664973204' WHERE `Matrix_Unique_ID` = '209329223' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T23:35:03.020' ,`MLSNumber` = '3908412' ,`ListAgentFullName` = 'Alvin Fang' ,`ListOfficeName` = 'Great Wall Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.155632' ,`Longitude` = '-94.273501' ,`PhotoCount` = '18' ,`PostalCode` = '77713' ,`RoomCount` = '3' ,`ListPrice` = '184900.00' ,`Status` = 'Active' ,`StreetName` = 'Leaning Oaks' ,`StreetNumber` = '13590' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Totally renovated house on a huge corner lot with separated storage shed. Convenient location in the quiet and safe Bevil Oaks City and easily access TX-105, 96 and I-10 to Beaumont City. All kichen and bathroom cabinet, countertop, appliance are new. New tile floor the whole house. Double car garage at the back of the building, and there is a big greenhouse attached to the back of the house.' ,`Acres` = '0.8004' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'RIVER OAKS ESTATES L1 B22' ,`LotDesciption` = 'Corner' ,`LotSize` = '34865' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '420' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'CHINA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'River Oaks Estates' ,`TaxAmount` = '3847' ,`TaxRate` = '2.0845' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664973205' WHERE `Matrix_Unique_ID` = '209844086' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T23:24:29.383' ,`MLSNumber` = '24723930' ,`ListAgentFullName` = 'Erica Nava' ,`ListOfficeName` = 'JEA Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792634' ,`Longitude` = '-95.479791' ,`PhotoCount` = '42' ,`PostalCode` = '77055' ,`RoomCount` = '8' ,`ListPrice` = '630000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridgewood' ,`StreetNumber` = '1265' ,`StreetSuffix` = 'Place' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2979' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare find! Charming brick home on a corner lot in a gated community. High ranked schools. Features 2-story ceilings, tons of natural light, generous closet & storage space, new porcelain tile on first floor, utility room w/ storage & washer/dryer. Kitchen w/ cabinets galore, lots of countertop space, a breakfast bar, island w/ a gas cooktop, & stainless steel refrigerator. Breakfast area w/ wall to ceiling windows. Large open area living room w/ floating fireplace & built-in cabinets/bookcases, 2-story ceilings & wall of windows. Primary BDRM on first floor, HIS & HER oversized closet w/ shelves & built-in drawers, Jetted tub, HIS & HER vanity. Huge separate formal dining area w/ crown molding. Formal living room w/ 2-story ceilings & a duel facing floating fireplace. Game room w/ built-in study nook & balcony overlooking the living room. All bedrooms are spacious w/ walk-in closets w/built-ins. Covered Patio. LOW TAX RATE, HOA takes care of it all; trash, water, sewer & landscaping.' ,`Acres` = '0.0964' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 RIDGEWOOD PLACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '4200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HUNTERS CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ridgewood Place' ,`TaxAmount` = '13078' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973205' WHERE `Matrix_Unique_ID` = '209973418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:22:35.003' ,`MLSNumber` = '34248278' ,`ListAgentFullName` = 'Cathy Carter' ,`ListOfficeName` = 'Carter Signature Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.141101' ,`Longitude` = '-95.044445' ,`PhotoCount` = '33' ,`PostalCode` = '77554' ,`RoomCount` = '5' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Liberty' ,`StreetNumber` = '4135' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy this Sea Isle home, with less than a 10-minute walk to sandy toes. Friends and family will enjoy the West End Marina, Sandbar and Palapa Bar, and a swim in the Community Pool after a fun day on the Tennis Courts. The home has open floorplan, with wood ceilings, storm shutters, kitchen with breakfast bar, 2 bedrooms, and bath. Feel the gulf breeze on the 2022 installed southern-facing deck with lift access and storm door. The ground floor has a garage, workshop, outdoor shower, and 1 bedroom with half bath. Home improvements include decking, stairs, pilings, lift, and exterior paint. The Golf Cart and furnishings to convey with home.' ,`Acres` = '0.1439' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 19 LOT 449 SEA ISLE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6270' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '230' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sea Isle Orig' ,`TaxAmount` = '3803' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973205' WHERE `Matrix_Unique_ID` = '210539510' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:31:25.147' ,`MLSNumber` = '19663584' ,`ListAgentFullName` = 'Cathy Lakey' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.400173' ,`Longitude` = '-95.500519' ,`PhotoCount` = '36' ,`PostalCode` = '77318' ,`RoomCount` = '0' ,`ListPrice` = '729000.00' ,`Status` = 'Active' ,`StreetName` = 'Irenic Mist' ,`StreetNumber` = '337' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3203' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Abundant natural light infuses this stunning one-story home sitting on a nearly half-acre cul-de-sac lot in one of the most popular master-planned communities in Montgomery County. Same floor plan as the Highland Homes model, loaded with upgrades, but priced far less than new! The heart of the home is a fabulous white kitchen loaded with cabinet space and accented by stylish gold drawer pulls, open to the living and dining area and facing a wall of windows overlooking the extended covered patio. The primary suite offers an oversized bedroom, a sumptuous ensuite bath with double vanities flanking a soaking tub, plus a separate seated vanity, an oversized shower and a huge walk-in closet with custom built-ins. Even the secondary bedrooms are sized generously. The entertainment room has the flexibility to be a theater, billiard or game room. The impressive private study features a 16-foot high ceiling, and five-inch plantation shutters finish off the glamorous flair of this home.' ,`Acres` = '0.4724' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S927100 - THE WOODLANDS HILLS 01, BLOCK 1, LOT 8' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '20576' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills 01' ,`TaxAmount` = '15390' ,`TaxRate` = '3.2823' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973205' WHERE `Matrix_Unique_ID` = '210955200' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:17:44.503' ,`MLSNumber` = '85333294' ,`ListAgentFullName` = 'Guolong Li' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.697396' ,`Longitude` = '-95.783874' ,`PhotoCount` = '32' ,`PostalCode` = '77406' ,`RoomCount` = '3' ,`ListPrice` = '384999.00' ,`Status` = 'Active' ,`StreetName` = 'San Ricci' ,`StreetNumber` = '23526' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2139' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This beautifully maintained Ashton Woods home is located in the highly sought-after Lakes of Bella Terra community, with easy access to West Park Tollway, Highway 99/Grand Parkway, and I-10. Zoned to top rated schools in LCISD. Everything about this home has been tastefully chosen. From the modern brick and stone elevation to the up-to-date interior paint colors, it’s a decorators dream. The 3 bedroom and 2 1/2 bathroom open floor plan makes it the perfect space for family and guests. This home boasts a variety of upgrades from luxury vinyl plank flooring, to shaker-style white kitchen cabinets, quartz countertops, and a private extended primary retreat complete with vaulted ceilings. Ready for the kids, the backyard has been made into your own private playground. Extensive neighborhood amenities include tennis courts, gym, pools, dog parks, scenic walking trails, and so much more. Call or text to schedule your private showing today!' ,`Acres` = '0.1452' ,`Area` = '37' ,`BuilderName` = 'Ashton woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF BELLA TERRA SEC 33, BLOCK 2, LOT 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lakes Of Bella Terra Sec 33' ,`TaxAmount` = '8185' ,`TaxRate` = '3.0848' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973205' WHERE `Matrix_Unique_ID` = '211191765' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:34:46.417' ,`MLSNumber` = '12579087' ,`ListAgentFullName` = 'Karen Shotwell' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.862701' ,`Longitude` = '-95.710738' ,`PhotoCount` = '22' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Little Pine' ,`StreetNumber` = '19503' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2246' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Estate Sale*** Welcome to 19503 Little Pine Ln. This 2-story, 3 bedroom, 2 1/2 bath, two car garage home is located in Katy Texas just minutes away from shopping, dining, and quick access to HWY 99, I 10, and 290. Walk through the elongated 8-foot front door to be welcomed by high ceiling, and an open floor plan, the kitchen has ample amount of cabinetry, walk-in pantry, granite countertops, spacious island and breakfast bar that opens to the family room, tile flooring throughout the first floor, half bath located off the living room. All bedrooms are located on the 2nd floor off the large game room. An immense primary bedroom features a private bathroom with two sinks, separate shower and tub, and a walk-in closet. providing additional entertainment space enjoy the evening out back under the patio. No flooding, no damage during the freeze. Call to schedule your private showings today.' ,`Acres` = '0.1212' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 123 BLK 2 PLANTATION LAKES SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '489' ,`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` = 'EMERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Lakes Sec 06' ,`TaxAmount` = '6642' ,`TaxRate` = '3.011' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973205' WHERE `Matrix_Unique_ID` = '211416660' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:13:19.150' ,`MLSNumber` = '78992109' ,`ListAgentFullName` = 'Javier Valencia' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759366' ,`Longitude` = '-95.877741' ,`PhotoCount` = '30' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Angel Trumpet' ,`StreetNumber` = '2210' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2515' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2500 Sqft ! LOVELY AND SPACIOUS! This home is perfect for gatherings with friends and family, you’ll be amazed of how much kitchen space you have when you see it in person! This 2016 build has exceptionally high ceilings and hardwood floors. Spacious family room with a fire place, a large breakfast room and a well sized office space. It has a spacious primary bedroom with a double sink restroom, tub, and walk in closet. Entertain guest with a outdoor covered patio and take advantage of a low maintenance back yard! You’ll have quick access to I-10 and zoned to KISD!' ,`Acres` = '0.1377' ,`Area` = '30' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FIRETHORNE WEST SEC 12, BLOCK 5, LOT 34' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Young Ranch' ,`TaxAmount` = '7704' ,`TaxRate` = '2.5848' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664973206' WHERE `Matrix_Unique_ID` = '211450545' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T23:01:18.317' ,`MLSNumber` = '61375959' ,`ListAgentFullName` = 'Leticia Rodriguez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.037345' ,`Longitude` = '-95.336725' ,`PhotoCount` = '9' ,`PostalCode` = '77373' ,`RoomCount` = '5' ,`ListPrice` = '185000.00' ,`Status` = 'Active' ,`StreetName` = 'Fallengate' ,`StreetNumber` = '6107' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1446' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Established community in the Spring ISD school district. Elementary school is just around the corner. Bush Airport, The Woodlands shopping/dining/entertainment, Exxon Complex, and major work centers and medical facilities are all just minutes away! Your large sofas will fit in this very spacious family room, and the cathedral ceiling gives it a more open feel. Make warm winter memories sitting in front of the cozy wood-burning fireplace. Keep the cook in the family company as you sit at the two breakfast bars. Plenty of windows overlook the big backyard. There is also a small courtyard at the front of the house that you will enjoy. \r\nNeeds TLC and is priced accordingly. Serious offers only. Please send proof of funds with all cash offers.' ,`Acres` = '0.1515' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 17 GREENGATE PLACE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '374' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greengate Place Sec 03' ,`TaxAmount` = '3763' ,`TaxRate` = '2.6867' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973206' WHERE `Matrix_Unique_ID` = '211849358' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:53:33.100' ,`MLSNumber` = '55863045' ,`ListAgentFullName` = 'Denise Martinez' ,`ListOfficeName` = 'Keller Williams Laredo' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.638578' ,`Longitude` = '-96.061983' ,`PhotoCount` = '17' ,`PostalCode` = '77485' ,`RoomCount` = '5' ,`ListPrice` = '115000.00' ,`Status` = 'Active' ,`StreetName` = 'Margie' ,`StreetNumber` = '705' ,`StreetSuffix` = 'Street' ,`City` = 'Wallis' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '652' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The property sits on an oversized lot in a quiet neighborhood. Has great potential and space to add square footage to this property. An Investor’s gem! Located 30 minutes away from Katy Mills Mall. Call to schedule your showing today!!!' ,`Acres` = '0.29' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HRANICKY SUB (OUT OF ABST 71) LOT 31' ,`LotDesciption` = 'Cleared' ,`LotSize` = '12810' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '54 - Brazos' ,`SchoolElementary` = 'BRAZOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOS HIGH SCHOOL' ,`SchoolMiddle` = 'BRAZOS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Hranicky Sub' ,`TaxAmount` = '1273' ,`TaxRate` = '2.5395' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664973206' WHERE `Matrix_Unique_ID` = '211858917' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T23:23:01.980' ,`MLSNumber` = '9664209' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751643' ,`Longitude` = '-95.878829' ,`PhotoCount` = '7' ,`PostalCode` = '77423' ,`RoomCount` = '8' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'Lemonwood' ,`StreetNumber` = '2719' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Village Builders Bristol Collection \"Pelham\" Plan with Elevation \"B\" in Jordan Ranch! This two-story home has a versatile layout that is perfect for those who need privacy. Two bedrooms are on the first floor, including the owner’s suite which features a private bathroom and walk-in closet. Also on the first floor is the open concept living area, which offers access to a back patio. Upstairs are two additional bedrooms, which center around a game room loft. **HOME ESTIMATED TO BE COMPLETE, DECEMBER 2022**' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0025 BLK 001 LOT 062' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664973206' WHERE `Matrix_Unique_ID` = '211865997' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:32:56.610' ,`MLSNumber` = '75777473' ,`ListAgentFullName` = 'Lisa Davis' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765399' ,`Longitude` = '-95.734154' ,`PhotoCount` = '31' ,`PostalCode` = '77450' ,`RoomCount` = '9' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Sherfield Ridge Dr' ,`StreetNumber` = '1302' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One Story w/a perfect Office w/door directly to the Double Wide Driveway; or Game Rm/Exercise Rm/Storage Rm. EXTRA STORAGE through out this home: Staircase in Garage opens to Attic w/Flooring & Shelving, Kitchen has tons of Upper Cabinets, 3 of the 4 Bedrooms have Walk-in Closets, Cabinets in Laundry & room for Fridge/Freezer, Double Linen Closets in Secondary Bath & Extra Walk-in Closet in the Hallway, Wet Bar has upper/lower Cabinets & working sink. Half Bath is full size & Secondary Rooms are large. Family Room wired for Surround Sound, PEX Plumbing through out, Granite on ALL Counter Tops, Vintage Intercom System to call kids for meals! RING Doorbell for convenience. Corner Lot has gorgeous Landscaping. \r\n**Holidays are coming. How nice to have all your decorations close by & drop the storage unit fee. Bring us an offer' ,`Acres` = '0.1956' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 16 NOTTINGHAM COUNTRY SEC 9' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'PATTISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Nottingham Country' ,`TaxAmount` = '6641' ,`TaxRate` = '2.3693' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973206' WHERE `Matrix_Unique_ID` = '212035004' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T23:00:26.120' ,`MLSNumber` = '91648562' ,`ListAgentFullName` = 'Christopher Harman' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Faith Reynolds' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.693328' ,`Longitude` = '-95.485163' ,`PhotoCount` = '50' ,`PostalCode` = '77081' ,`RoomCount` = '21' ,`ListPrice` = '2099999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Valerie' ,`StreetNumber` = '5503' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '8' ,`SqFtTotal` = '7169' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning updated traditional exterior complete with modern interior finishes located on the coveted Valerie Street in pristine Braeburn Country Club Estates boasts unsurpassed quality & detail. Enter via the dramatic two story (~23ft) diamond plastered foyer greeted by soaring under lite white oak stairs coupled perfectly /w solid black iron balusters & railing. Grand foyer flanked by elegantly appointed Formal Dining. Enter spacious family room boasting sixteen-foot sliding glass door overlooking much to be desired backyard & chef’s kitchen complete w/ show piece ~1,200 bottle fully insulated climate controlled glass wine cellar, double islands, Calcutta Miraggio countertops, hidden walk-in pantry, 60” commercial grade range complete /w 8 (not 6) burners & 12” griddle, 42” custom paneling Jenn-Air refrigerator, & Silhouette Pro under counter ice maker. Zoned to newly built Bellaire High School this is a truly must-see home minutes from Galleria & Medical center. No Flooding.' ,`Acres` = '0.47' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 17 BRAEBURN CNTRY CLUB ESTS SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRAEBURN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'LONG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Braeburn Cntry Club Estate' ,`TaxAmount` = '26763' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973207' WHERE `Matrix_Unique_ID` = '212196239' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T23:06:18.503' ,`MLSNumber` = '19358885' ,`ListAgentFullName` = 'Alexander DiSaggio' ,`ListOfficeName` = 'City Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.089603' ,`Longitude` = '-94.114327' ,`PhotoCount` = '12' ,`PostalCode` = '77701' ,`RoomCount` = '8' ,`ListPrice` = '135000.00' ,`Status` = 'Active' ,`StreetName` = 'Harrison' ,`StreetNumber` = '1897' ,`StreetSuffix` = 'Street' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1822' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Huge professional add-on in back can be used as a 4th bedroom. Great home for a great price! If you are a landlord looking for a turn key property, this is it! Home is leased out until August 2023 at 1,325 a month. This home is for INVESTORS ONLY. PLEASE DO NOT DISTURB TENANTS.' ,`Acres` = '0.1722' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MC FADDIN 2 L10 B31 & ADJ 1/2 ALLEY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'CALDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'ODOM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mcfaddin Add' ,`TaxAmount` = '1780' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973207' WHERE `Matrix_Unique_ID` = '212230872' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T23:17:51.247' ,`MLSNumber` = '12383124' ,`ListAgentFullName` = 'Maria Salhuana Denegri' ,`ListOfficeName` = 'Soluna Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.761778' ,`Longitude` = '-95.870112' ,`PhotoCount` = '35' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Canyon Oak' ,`StreetNumber` = '29006' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3039' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perry Home with multiple upgrades including a large covered patio, office/library with french doors by the entrance, formal dining room in addition to a game-room area, and sprinklers system to just mention a few. The kitchen features a large island with Quartz countertops and modern wooden-look tile in the common areas. The Firethorne community offers sports fields, a swimming pool, a beautiful lake, trails, tennis courts, and an indoor exercise facility.' ,`Acres` = '0.1902' ,`Area` = '30' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FIRETHORNE WEST SEC 17, BLOCK 1, LOT 18' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8283' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Firethorne West Sec 17' ,`TaxAmount` = '9749' ,`TaxRate` = '2.5848' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664973207' WHERE `Matrix_Unique_ID` = '212237313' --> 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','212289240','1664973207','212289240','2022-10-04T23:37:50.873','13579230','Charlie Russo','RE/MAX Signature','','','29.679111','-95.744111','38','77407','12','600000.00','Active','Somerset Valley','6006','Drive','Richmond','3','1','4','3460','Single-Family','Magnificently designed executive level home located in Long Meadow Farms. This Drees Custom Homes Palmetto plan is perfect for entertaining. The home features 4 full bedrooms, 3 car garage, first floor game room, work from home study & a large open concept family room. Dream extended island in kitchen with two sinks, SS appliances, including double ovens and 5 burner gas cooktop, furniture grade 42 \'\' Benedittini cabinetry & huge, customized pantry. Upgraded 8’ entry door opens to soaring entryway ceiling height. The large Primary Suite is separate from all other bedrooms. Abundant light & high-end finishes throughout. Other home features include water softener system, 2 tankless water heaters, sprinkler systems, wood flooring in all areas except the bedrooms and baths, upgraded countertops in all areas, additional cabinet and counters in the utility room, Environments for Living Energy Program with significant energy savings for the owner. Make this home a priority to see in person.','0.1928','37','Drees Custom Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Freestanding,Gaslog Fireplace','1','Fort Bend County North/Richmond','Central Gas','1','LONG MEADOW FARMS SEC 43, BLOCK 2, LOT 23','Subdivision Lot','8400','Appraisal District','','875','0','','3','Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','ADOLPHUS ELEMENTARY SCHOOL','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal','1','Traditional','Long Meadow Farms Sec 43','13048','2.9048','Water District','2019','Seller'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:51:32.153' ,`MLSNumber` = '85552878' ,`ListAgentFullName` = 'Lakisha Johnson' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749848' ,`Longitude` = '-95.896706' ,`PhotoCount` = '28' ,`PostalCode` = '77423' ,`RoomCount` = '8' ,`ListPrice` = '455000.00' ,`Status` = 'Active' ,`StreetName` = 'Agave Circle' ,`StreetNumber` = '30518' ,`StreetSuffix` = 'Court' ,`City` = 'Brookshire' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Chesmar Home in Jordan Ranch built in 2020! Hillcrest floor plan with optional 4th bedroom w/$30k in upgrades. Open concept floor plan with a spacious family room that connects to kitchen and casual dining area. Kitchen features stainless steel appliances, granite countertops, and plenty of cabinet space. Master retreat tucked towards the back of the home for maximum privacy. Master en suite includes double sinks, separate tub & shower and spacious walk-in-closet. This floor plan also features a study/home office. A great backyard space with covered patio. Upgrades included in this home are fireplace, appliance package, tile flooring, granite upgrade, 8 feet entry doors on front & back door, and much more!! Schedule your private tour TODAY!!' ,`Acres` = '0.1584' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'JORDAN RANCH SEC 17, BLOCK 2, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6898' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch Sec 17' ,`TaxAmount` = '9600' ,`TaxRate` = '3.2723' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973207' WHERE `Matrix_Unique_ID` = '212294298' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:47:15.783' ,`MLSNumber` = '53935917' ,`ListAgentFullName` = 'Dominique Johnson' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.473071' ,`Longitude` = '-95.148153' ,`PhotoCount` = '41' ,`PostalCode` = '77573' ,`RoomCount` = '11' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Pilgrim Oaks' ,`StreetNumber` = '5235' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4546' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your oasis awaits! Stunning home on a corner lot in the Magnolia Creek Golf Club community. Highly desirable floor plan ideal for both entertaining and daily function, this home has it all. Formal dining with easy access to the kitchen makes dinner parties a breeze! The kitchen is eye-catching with its beamed ceilings, exposed brick, and granite countertops. The chef of the home will delight at the gas cooktop, breakfast bar, center island, and stainless steel appliances. Main level family room boasts soaring high ceilings and a gorgeous floor to ceiling brick fireplace. Spacious primary bedroom on the main level offers a peaceful retreat with bay windows, tray ceiling, and a luxurious bath en suite. Unwind in the corner soaking tub after a long day! Plenty of space upstairs with additional bedrooms, more living space, and dedicated media room. Incredible backyard with a sparkling in-ground pool, covered patio space with ceiling fans, large grassy yard - the options are endless!' ,`Acres` = '0.2763' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MAGNOLIA CREEK SEC 4 PH 1 (2000) ABST 607, BLOCK 2, LOT 1, A' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '12037' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '726' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GILMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Creek Sec 4 Ph 2' ,`TaxAmount` = '10581' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973207' WHERE `Matrix_Unique_ID` = '212369609' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T23:20:34.093' ,`MLSNumber` = '10920712' ,`ListAgentFullName` = 'Richard Fenyes' ,`ListOfficeName` = 'Rocket, Realtors' ,`SellingAgentFullName` = 'Jay Bustos' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.847020' ,`Longitude` = '-95.344888' ,`PhotoCount` = '16' ,`PostalCode` = '77093' ,`RoomCount` = '4' ,`ListPrice` = '209000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Shoreham' ,`StreetNumber` = '9401' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1132' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2022,EVERYTHING NEW(NOT A FLOOD ZONE, LOW TAXES & NO HOA)3-bedroom flat.If your looking for a completely renovated home done with great care,complete with upgrades and updates,I think you found-it. Home has brand-NEW ROOF 22\',BRAND NEW HVAC even the ductwork is BRAND NEW,all NEW siding, flooring,paint,horizontal 5-panel doors,new energy efficient dual pane vinyl frame windows w/easy clean feature,IN-HOME UTILITY/LAUNDRY room,new water heater.Many upgrades also include LED recessed lighting package,ceiling fan w/lighting throughout home,new 2\"faux wood white window treatments(BLINDS),REAL TILE floors in all wet areas(kitchen/bath/laundry),ALL APPLIANCES INCLUDED(REF.credit$1200,FRONT LOAD WASHER & DRYER).The spacious kitchen is well appointed with QUARTZ COUNTERTOPS,recessed LED lighting,white painted cabinetry w/stainless steel pull-hardware.Home features an awesome well sized exterior side patio and a large backyard.The home really is nice with everything harmoniously coming together' ,`Acres` = '0.1446' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 1 SHOREHAM PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARCIA ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'PATRICK HENRY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shoreham Place' ,`TaxAmount` = '1885' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973207' WHERE `Matrix_Unique_ID` = '212374344' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T23:09:23.750' ,`MLSNumber` = '75162358' ,`ListAgentFullName` = 'Lois De Armas' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Li-ching Chen' ,`SellingOfficeName` = 'Pillar Realty & Associates' ,`Latitude` = '29.662632' ,`Longitude` = '-95.729630' ,`PhotoCount` = '50' ,`PostalCode` = '77407' ,`RoomCount` = '9' ,`ListPrice` = '324900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lake Wichita' ,`StreetNumber` = '4831' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2490' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'JUST IN TIME FOR THE HOLIDAYS! Enjoy this fabulous home year round! 4 bedrooms/2.5 baths! Impressive entry w/high ceilings & updated fixtures thru-out! Formal dining features built-in bookshelves w/recessed lighting & cabinet storage. New quartz counters in galley style kitchen w/stainless appliances & tile backsplash! Laminate wood floors thru entry, formal dining, living & primary bedroom! Living room features wall of windows & updated ceiling fan! Spacious primary bedroom w/sitting area! Primary bath w/separate shower & garden tub! Huge bonus walk-in closet w/built-in vanity space. Additional storage closets on 1st & 2nd floor! Upstairs large game room plus 3 secondary bedrooms w/large closets & updated ceiling fans! Updated secondary bathroom w/new tile shower surround, double sinks & cabinet storage! The backyard patio has extended concrete to enjoy all things leisure! EZ access to Grand PKWY & Mason! Near retail, dining, parks & so much more! NEVER FLOODED! LOW TAXES! MUST HAVE!' ,`Acres` = '0.1263' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WATERSIDE VILLAGE SEC 2, BLOCK 2, LOT 86' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '690' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OAKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterside Village' ,`TaxAmount` = '5306' ,`TaxRate` = '2.2929' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973208' WHERE `Matrix_Unique_ID` = '212397462' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:05:05.133' ,`MLSNumber` = '15691997' ,`ListAgentFullName` = 'Amanda Klam' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.868175' ,`Longitude` = '-95.878157' ,`PhotoCount` = '23' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Wayne County' ,`StreetNumber` = '305' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1570' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Style meets functionality in this open and spacious layout with 3 bedrooms and 2 bathrooms. The open kitchen with a sprawling breakfast bar, a spacious family room and a private dining room makes the perfect layout for entertaining. A spacious covered patio and fully fenced backyard extends the entertaining space outdoors.' ,`Acres` = '0.1876' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brookshire' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S491903 FREEMAN RANCH SECTION 3 BLK 14 LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8172' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '348' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '44 - Royal' ,`SchoolElementary` = 'ROYAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROYAL HIGH SCHOOL' ,`SchoolMiddle` = 'ROYAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Freeman Ranch Sec 3' ,`TaxAmount` = '' ,`TaxRate` = '2.8667' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973208' WHERE `Matrix_Unique_ID` = '212412567' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:13:02.083' ,`MLSNumber` = '14377610' ,`ListAgentFullName` = 'Christy Bulerez-Wyatt' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.529397' ,`Longitude` = '-95.382264' ,`PhotoCount` = '18' ,`PostalCode` = '77578' ,`RoomCount` = '5' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Rippling Bend' ,`StreetNumber` = '2618' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful Ashton Woods home in Silvercreek has so much to offer with no back neighbors. This 3 bedroom, 2 bathroom, 2 car garage home includes a beautiful formal dining room, large living area, island kitchen and spacious game room upstairs (pool table included). The back yard features a covered patio with fans and recessed lighting, a 12X12 workshop with electricity & water and an outdoor sink station. NEW flooring in 2016, NEW fence installed 4 years ago, NEW blue tooth garage door opener installed in 2020, NEW microwave installed in 2022, NEW water heater and drip pan in A/C installed in 2021. Washer & dryer included with the sale of the home. This beautiful home has been meticulously cared for with exceptional maintenance. Schedule your private home tour TODAY!' ,`Acres` = '0.1515' ,`Area` = '5' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SILVERCREEK SEC 9 (A0415 ACH&B) BLK 2 LOT 30' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6599' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '662' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SILVERCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Silvercreek Sec 1-2-3-4-5-6-7-' ,`TaxAmount` = '6414' ,`TaxRate` = '2.4537' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973208' WHERE `Matrix_Unique_ID` = '212462171' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T23:42:36.490' ,`MLSNumber` = '21977345' ,`ListAgentFullName` = 'Debbie Bender' ,`ListOfficeName` = 'Town & Country Realty and Mortgage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.888531' ,`Longitude` = '-95.687886' ,`PhotoCount` = '38' ,`PostalCode` = '77433' ,`RoomCount` = '14' ,`ListPrice` = '374995.00' ,`Status` = 'Active' ,`StreetName` = 'Parkcross' ,`StreetNumber` = '7526' ,`StreetSuffix` = 'Place' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2659' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful custom David Weekly home at end of large cul-de-sac lot. Brick on 3 sides & Hardi board in back. Landscaping includes magnolia, apple tree, flowering plants, plus raised beds for an herb garden. Leaded glass door opens to entry & solid oak staircase. Engineered hardwood floors & slate tile add warmth to main areas downstairs. Kitchen has granite countertops, gas cooktop, warming drawer, pantry, desk space & black stainless French door refrigerator. Breakfast nook has hidden storage in benches. Large windows allow natural light in. Home is wired for sound. Primary bedroom is downstairs & has French doors which open to backyard. Second bedroom & full bath downstairs. Game room / family room at top of stairs. 2 of 3 bedrooms upstairs currently used as hobby/workrooms. Westgate Subdivision has walking paths, parks, pool w/ splashpad, soccer field & gazebo plus courtesy patrol. Per seller, home has never flooded. Cypress-Fairbanks ISD' ,`Acres` = '0.2224' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 WESTGATE SEC 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9688' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'COPELAND ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westgate' ,`TaxAmount` = '6606' ,`TaxRate` = '2.671' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973208' WHERE `Matrix_Unique_ID` = '212469309' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:01:52.087' ,`MLSNumber` = '25622984' ,`ListAgentFullName` = 'Jill Smith' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.908308' ,`Longitude` = '-95.675110' ,`PhotoCount` = '32' ,`PostalCode` = '77095' ,`RoomCount` = '12' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Hollow Bay' ,`StreetNumber` = '8722' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4286' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2-story home in Copper Lakes. 4 bedrooms (2 downstairs), 4.5 bathrooms, formal dining room, study, game room and media room. This home has it all! Incredible island kitchen features granite countertops, stainless steel appliances with a gas cooktop, lovely white cabinetry and slate backsplash. The spacious family room boasts a soaring ceiling, entertainment niche and a gas log fireplace. Large master retreat with en-suite bathroom complete with his/her vanities, whirlpool tub, oversized shower and walk-in closet with built-ins. Hand scraped hardwood flooring, crown molding, art niches, wrought iron staircase spindles and more! Both a/c units replaced in 2021. Access to Copper Lakes community center, 2 pools, splash pads, playgrounds, tennis courts, beautiful walking paths with lakes and fountains. Zoned to award-winning Cypress Fairbanks ISD. Conveniently located by shopping, restaurants and recreational areas. Easy access to Hwy. 290 and Grand Parkway.' ,`Acres` = '0.2072' ,`Area` = '8' ,`BuilderName` = 'Trendmaker' ,`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' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 5 COPPER LAKES SEC 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9025' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '915' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'COPELAND ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copper Lakes' ,`TaxAmount` = '11248' ,`TaxRate` = '2.775' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973208' WHERE `Matrix_Unique_ID` = '212469787' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:32:13.053' ,`MLSNumber` = '65956806' ,`ListAgentFullName` = 'Connie Buck' ,`ListOfficeName` = 'Lucid Realty, LLC' ,`SellingAgentFullName` = 'Silvia Quintanilla' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.776560' ,`Longitude` = '-95.241484' ,`PhotoCount` = '5' ,`PostalCode` = '77013' ,`RoomCount` = '3' ,`ListPrice` = '120000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Westshire' ,`StreetNumber` = '705' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2154' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTMENT PROPERTY ON BEAUTIFUL, HUGE LOT, DIRECTLY ACROSS THE STREET FROM SONGWOOD PARK. LOCATED ONE BLOCK AWAY FROM FURR HIGHSCHOOL. CENTRALLY LOCATED OFF OF I-10 AND 610 AND ONLY TEN MINUTES FROM DOWNTOWN!\nDEADLINE FOR HIGHEST AND BEST OFFERS IS SAT OCT 1 @ NOON. ' ,`Acres` = '0.1763' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 5 MEADOWOOD ESTATES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHITTIER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'FURR HIGH SCHOOL' ,`SchoolMiddle` = 'HOLLAND MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Meadowood Estates' ,`TaxAmount` = '4627' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973209' WHERE `Matrix_Unique_ID` = '212471218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:37:01.073' ,`MLSNumber` = '57477569' ,`ListAgentFullName` = 'Stuart Groves' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.716319' ,`Longitude` = '-95.522911' ,`PhotoCount` = '19' ,`PostalCode` = '77036' ,`RoomCount` = '8' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'Prestwood' ,`StreetNumber` = '7815' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2055' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite, 2,000 sqft plus traditional, single family home built on corner lot in 1970. Cloaked in suburban charm, this home was professionally designed and includes soaring ceilings, chef\'s kitchen and over- sized windows throughout. The 4 bedroom/2 bath residence was impeccably designed to enjoy the serenity and beauty of outer-loop living. Richly appointed wood and tile floors are paired with bright accents throughout. Standout features include a kitchen with top-of-the-line appliances, 2-car garage, and additional storage. Back yard entrance opens fully to create a single indoor/outdoor living space with an over-sized corner lawn (12,540 sqft) as an elegant backdrop. Property has never flooded/ lost power in previous storm history. Carefully situated amongst local eateries, Bellaire Blvd., Westpark Tollway, and Southwest Freeway.' ,`Acres` = '0.2879' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 10A BLK 15 SHARPSTOWN COUNTRY CL EST 3 RP' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '12540' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'EMERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharpstown Country Clb Estate 3 P' ,`TaxAmount` = '4965' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973209' WHERE `Matrix_Unique_ID` = '212522413' --> 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','212524844','1664973209','212524844','2022-10-04T23:18:59.200','10283361','Jared Turner','LennarVillageBldr-JaredTurner','','','29.510819','-95.444968','17','77583','8','280000.00','Active','Hurston Park','5015','Trail','Rosharon','2','1','4','2229','Single-Family','NEW! Lennar Cottage Collection \"Linden\" Plan with Elevation \"A\" in Lakes of Savannah! This two-story home has a smart layout that offers space and versatility. The front door leads into the family room which connects with a dining area and kitchen around the corner in a flexible open layout. Upstairs are four bedrooms, including the owner’s suite, which features a private bathroom and walk-in closet. *HOME ESTIMATED TO BE COMPLETE, OCTOBER, 2022*','','38','Lennar','','','','Mud,Other Disclosures','1','','0','Missouri City Area','Central Gas','1','SEC 0021 BLK 003 LOT 019','Subdivision Lot','','','','950','1','To Be Built/Under Construction','2','','0','','','','','Composition','19 - Fort Bend','HERITAGE ROSE ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','BAINES MIDDLE SCHOOL','Appointment Required','Builder','2','Traditional','Lakes of Savannah','','3.093','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:41:42.900' ,`MLSNumber` = '83741359' ,`ListAgentFullName` = 'Paige Pigott' ,`ListOfficeName` = 'Charger Realty' ,`SellingAgentFullName` = 'Paige Pigott' ,`SellingOfficeName` = 'Charger Realty' ,`Latitude` = '30.485402' ,`Longitude` = '-95.196802' ,`PhotoCount` = '23' ,`PostalCode` = '77328' ,`RoomCount` = '3' ,`ListPrice` = '199000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Fm 945' ,`StreetNumber` = '6121' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2018 singlewide mobile home sitting on well manicured one acre lot in the Evergreen area. Home has three bedrooms and two bathrooms, ceiling fans, island kitchen, front and back deck, small decorative fish pond at front patio with gold fish. This home is move in ready as you can see from the photos. Second septic system, water hook-up and utility pole. This property has a 30x40 hobby shop for him or for her. Included in the sale of this home is a Generac manual 12,000 generator that is already hooked up for emergencies. There is also an R.V hookup behind the mobile home.' ,`Acres` = '1.0122' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A014 VITAL FLORES, TRACT 167, HUD# PFS1212853, ACRES 1.0122' ,`LotDesciption` = 'Cleared' ,`LotSize` = '44091' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Vital Flores' ,`TaxAmount` = '1863' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973209' WHERE `Matrix_Unique_ID` = '212580319' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T23:08:14.753' ,`MLSNumber` = '47732439' ,`ListAgentFullName` = 'Viviana Garcia' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.695067' ,`Longitude` = '-95.790311' ,`PhotoCount` = '20' ,`PostalCode` = '77406' ,`RoomCount` = '8' ,`ListPrice` = '470000.00' ,`Status` = 'Active' ,`StreetName` = 'Ibisco' ,`StreetNumber` = '12014' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2854' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful home located on a corner lot with beautiful curb appeal, on a quiet cul-de-sac street.\r\nExtended porch in front and back. Spacious open layout with 4 bedrooms, 3.5 baths, game room, breakfast, and formal dining/office. A beautiful large open kitchen with an oversized granite top is great for entertaining, stainless steel built-in appliances, and pendant lights over the large granite top in the kitchen. Brushed nickel lighting package 42\'\' maple espresso cabinets in kitchen with stainless steel sink and pull-out arbor faucet. This home has a very large game room that is great for entertaining guests. Double pane tilt sash Low E windows. Sprinkler system, Gaslog fireplace, Master suite w/jetted tub, separate shower, double sinks & walk-in closet. No neighbors on the North side. Excellent rated school district.\r\nThe seller is accepting the highest and best offer!' ,`Acres` = '0.1473' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF BELLA TERRA SEC 35, BLOCK 1, LOT 32' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6417' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Lakes Of Bella Terra' ,`TaxAmount` = '9656' ,`TaxRate` = '3.0848' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973209' WHERE `Matrix_Unique_ID` = '212587685' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:36:38.687' ,`MLSNumber` = '57044487' ,`ListAgentFullName` = 'Veronica Alarcon' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.008388' ,`Longitude` = '-95.298847' ,`PhotoCount` = '25' ,`PostalCode` = '77338' ,`RoomCount` = '8' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Heaton Hall' ,`StreetNumber` = '8311' ,`StreetSuffix` = 'Street' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Older home with character but updated to fit a modern boho vibe! Sellers have spent a lot of time and money in making this home feel new and updated! Ask your realtor for the list of updates! Comes see this gorgeous gem on a large corner lot! The sky is the limit with what you can do with this space!! Long Living room and huge backyard! Community Pool and tennis courts. This will not last! Schedule a tour today!!\r\n**Room sizes to be verified by buyer** 2019 Water Heater replaced / 2020 AC Unit replaced / 2021 New Roof installed (full updates available in attachments).' ,`Acres` = '0.2166' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 KENSWICK SEC 1 R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '9433' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kenswick Sec 01 R/P' ,`TaxAmount` = '3504' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973209' WHERE `Matrix_Unique_ID` = '212625735' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T23:59:29.667' ,`MLSNumber` = '17712400' ,`ListAgentFullName` = 'William Horn' ,`ListOfficeName` = 'Divvy Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.907833' ,`Longitude` = '-95.462061' ,`PhotoCount` = '31' ,`PostalCode` = '77038' ,`RoomCount` = '10' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Audubon Hill' ,`StreetNumber` = '12007' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1847' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING opportunity to own this beautifully maintained 3-bedroom 2.5 bath cul-de-sac home in Willow Springs! The 1st floor features all laminate flooring, a huge eat-in kitchen with brand-new stainless-steel appliances, fireplace and dedicated office space, perfect for working from home. Upstairs you will find all 3 bedrooms, a convenient laundry area and a very spacious 2nd living area or game room. The home has been recently updated with brand new carpet, ceiling fans, light fixtures, plumbing fixtures and beautiful custom paint! The seller has taken care of everything! All you have to do is move in and enjoy!' ,`Acres` = '0.0799' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 1 WILLOW SPRINGS SEC 5' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '3479' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '460' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARTER ACADEMY' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'SHOTWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Springs' ,`TaxAmount` = '5548' ,`TaxRate` = '3.4553' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973209' WHERE `Matrix_Unique_ID` = '212632346' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:01:17.097' ,`MLSNumber` = '32513282' ,`ListAgentFullName` = 'Laura Lane' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659918' ,`Longitude` = '-95.108333' ,`PhotoCount` = '17' ,`PostalCode` = '77571' ,`RoomCount` = '4' ,`ListPrice` = '209500.00' ,`Status` = 'Active' ,`StreetName` = 'Ashwyne' ,`StreetNumber` = '8414' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Roof replaced Sept 2020. Pipes replaced with PEX Feb 2021. Garage door panels replaced Sept 2022. Walls painted Sept 2022. Cute starter home with covered back porch. granite counter tops in kitchen and bathrooms. Only minuets away from Shopping, restaurants, grocery stores and more. Very close to San Jacinto college central campus.All measurements are estimated, please verify.' ,`Acres` = '0.1446' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 6 BROOKGLEN SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'COLLEGE PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookglen Sec 02 R/P' ,`TaxAmount` = '4760' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973210' WHERE `Matrix_Unique_ID` = '212651125' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:18:21.600' ,`MLSNumber` = '57615569' ,`ListAgentFullName` = 'Irene Leal' ,`ListOfficeName` = 'Nexus One Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797638' ,`Longitude` = '-95.688111' ,`PhotoCount` = '34' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Waterelm' ,`StreetNumber` = '2011' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautifully updated and open floor-plan home featuring 3 bedrooms, 2 bathroom, upgrades include light fixtures, fully renovated bathroom, granite counter tops, covered patio, fresh paint throughout the interior and exterior. The backyard has been updated and features concrete/tile pavers lined with gray pebble rocks. It has a modern and low maintenance feel! Click to video icon.' ,`Acres` = '0.1567' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 77 BLK 1 MAYDE CREEK FARMS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Mayde Creek Farms Sec 01' ,`TaxAmount` = '4416' ,`TaxRate` = '2.4889' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973210' WHERE `Matrix_Unique_ID` = '212724217' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T23:55:55.093' ,`MLSNumber` = '58870989' ,`ListAgentFullName` = 'Cortni Emanuel' ,`ListOfficeName` = 'Peters Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.511649' ,`Longitude` = '-95.518203' ,`PhotoCount` = '40' ,`PostalCode` = '77459' ,`RoomCount` = '12' ,`ListPrice` = '1284000.00' ,`Status` = 'Active' ,`StreetName` = 'Westpoint' ,`StreetNumber` = '23' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home in the prestigious Westpoint Estates in Sienna. This home offers spectacular living in a secluded location. Situated on just under 2 acres. This property is for buyers that love elegance. As you enter this beauty, you are met with a dramatic grand entrance and high ceilings. SWEEPING views from every angle of the house. Over 350k worth of upgrades! Relax and entertain in the extravagant wet bar. The chef’s kitchen is finished with quartz countertops and state-of-the-art appliances. Designer custom features are throughout the home. This home offers a luxurious grand master bedroom and ensuite with a fireplace, lighted mirrors, and seamless shower glass with his and her closets. Additional bedroom and ensuite on the first floor for guests. As you make your way up the custom spiral staircase to the multipurpose game room, the views over the home are breathtaking. While in the game room, walk out on your new balcony and imagine your lavish Infinity Edge Pool & Jacuzzi.' ,`Acres` = '1.831' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTPOINT ESTATES SEC 1, BLOCK 1, LOT 1, ACRES 1.831' ,`LotDesciption` = 'Corner,In Golf Course Community,Water View' ,`LotSize` = '79758' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westpoint Estates Sec 1' ,`TaxAmount` = '15296' ,`TaxRate` = '2.34' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973210' WHERE `Matrix_Unique_ID` = '212746061' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:06:31.510' ,`MLSNumber` = '11227790' ,`ListAgentFullName` = 'Alexis Skeen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.216150' ,`Longitude` = '-95.597129' ,`PhotoCount` = '48' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = 'Clubhouse' ,`StreetNumber` = '10603' ,`StreetSuffix` = 'Circle' ,`City` = 'Magnolia' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4913' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SPECTACULAR home on Lake Windcrest golf course!!\r\nThis home features luxurious interior finishes throughout. \r\nSpacious floor plan has both formals, wine grotto, four bedrooms down (includes primary), large laundry with outdoor access & a game-room upstairs. \r\nPrimary Bathroom has been redesigned with double vanities coupled with double closets, spacious walk in shower, and a deep soaking tub.\r\nThe kitchen comes complete with new appliances, quartz countertops, and Large island with lots of cabinetry.\r\nLooking out the back windows you will see a beautiful Manicured backyard that accompanies a pool & spa, HUGE covered patio that features outdoor fireplace & full kitchen. \r\nComplete with a one bedroom guest house with private bath.\r\nPerfect for entertaining!! \r\nTHIS IS A MUST SEE!! Schedule your appointment today ;)' ,`Acres` = '1.048' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LAKE WINDCREST 05, BLOCK 1, LOT 20' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '45651' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Windcrest Sec 5' ,`TaxAmount` = '12377' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973210' WHERE `Matrix_Unique_ID` = '212749957' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T23:00:50.987' ,`MLSNumber` = '44614219' ,`ListAgentFullName` = 'Javier Tello' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = 'Raul Limas' ,`SellingOfficeName` = 'Keller Williams Realty - Memorial' ,`Latitude` = '29.714280' ,`Longitude` = '-95.862052' ,`PhotoCount` = '22' ,`PostalCode` = '77441' ,`RoomCount` = '12' ,`ListPrice` = '915000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Starlight Harbor' ,`StreetNumber` = '28015' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5036' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous 2 story lake front home is located in Sora Lakes in one of the nations top selling master planned\r\ncommunities, Cross Creek Ranch. Featuring 5 bedrooms, 5 and a half bathrooms, a media room on the first floor\r\nas well as 2 game rooms, one on the first and second floor. Primary and secondary bedroom are located on the\r\nfirst floor and 3 bedrooms are located on the second floor. A gorgeous kitchen overlooks the livingroom,\r\nbreakfast area and gameroom and features double islands in a space that is perfect for entertaining. Large yard\r\nfeaturing a covered patio with a stunning pool and spa overlooking a magnificent view of the lake! Zoned to\r\nhighly sought after Katy ISD schools! Schedule your tour today!\r\nELEVATED MOLD PRESENT IN HOME, PRICE REFLECTS MOLD CONDITION\r\n\r\nPlease have your agent review the agent remarks in the MLS before scheduling appointment.' ,`Acres` = '0.327' ,`Area` = '36' ,`BuilderName` = 'TrendMaker' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK COVE AT CROSS CREEK RANCH SEC 8, BLOCK 1, LOT 29' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '14245' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JAMES E RANDOLPH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Creek Cove At Cross Creek Ranch Sec 8' ,`TaxAmount` = '25362' ,`TaxRate` = '3.1375' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973210' WHERE `Matrix_Unique_ID` = '212818767' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T23:22:21.433' ,`MLSNumber` = '80394002' ,`ListAgentFullName` = 'Richard Fenyes' ,`ListOfficeName` = 'Rocket, Realtors' ,`SellingAgentFullName` = 'Phuoc Hai Nguyen' ,`SellingOfficeName` = 'B & W Realty Group LLC' ,`Latitude` = '30.068461' ,`Longitude` = '-95.390804' ,`PhotoCount` = '21' ,`PostalCode` = '77373' ,`RoomCount` = '8' ,`ListPrice` = '345000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Little Forest' ,`StreetNumber` = '2506' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3385' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super clean and spacious home(NOT A FLOOD ZONE)on a quiet cul-de-sac street with great accessibility to major thoroughfares(I45/Hardy Toll),close to shopping.The home features beautiful entry with both formals and an amazing open-to-below living,overlooked by a stunning 2 story wall of windows,providing aesthetically pleasing architecture also great natural lighting.The 1st Floor large Primary bedroom is very elegantly nestled away from living areas providing privacy.The Primary Bath is really nice w/dual vanities,SEPARATE GARDEN TUB AND SHOWER ENCLOSURE and a big Primary walk-in closet.The home has very nice structural upgrades,with soaring & elevated ceilings,island kitchen w/electric outlet, an in-home laundry with good space,tile in all wet areas,1st floor POWDER GUEST BATH, spacious game room w/privacy Den/Study and an elongated driveway great for guest/family.The backyard is spacious also includes a concrete pad which is great for outdoor living.The home is just clean and nice.' ,`Acres` = '0.1716' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 5 BRADBURY FOREST SEC 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'JOHN WINSHIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bradbury Forest Sec 03' ,`TaxAmount` = '7175' ,`TaxRate` = '2.8117' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973211' WHERE `Matrix_Unique_ID` = '212886670' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:28:09.790' ,`MLSNumber` = '32539381' ,`ListAgentFullName` = 'Kevin King' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819356' ,`Longitude` = '-95.071064' ,`PhotoCount` = '34' ,`PostalCode` = '77562' ,`RoomCount` = '9' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Hampton' ,`StreetNumber` = '307' ,`StreetSuffix` = 'Court' ,`City` = 'Highlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2147' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a move-in ready 4 bedroom home in an established neighborhood within walking distance to tennis courts, walking track, splash pad, pavilion, playground and Highlands Community Center? Look no further because this is the home for you. 1 owner home with a split floorplan, all tile flooring, fireplace, formal dining and located on a Cul-de-sac street. Close to shopping and I-10. Community also has a boat ramp for access to the San Jacinto River. This home is a must see.' ,`Acres` = '0.1584' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 4 HIGHLAND WOODS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '212' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Woods Sec 02' ,`TaxAmount` = '4995' ,`TaxRate` = '2.575' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973211' WHERE `Matrix_Unique_ID` = '212937920' --> 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','212949439','1664973211','212949439','2022-10-04T22:13:16.387','76593576','Linda Hulsey','Coldwell Banker Realty','','','29.780964','-95.386613','1','77009','12','1100000.00','Active','Usener','1113','Street','Houston','2','1','3','2478','Single-Family','This classically styled brick facade with charming front porch~and a 2nd story balcony with views of Downtown is nestled in Houston Heights with an elegant presence on Usener St. It\'s walking distance to local restaurants and the White Oak Hike and Bike trail. Being centrally located, one has easy access to Downtown, the Medical Center,Museum District and the Energy Corridor! Graciously proportioned rooms with the large Primary Suite downstairs, open concept and clerestory windows create a graceful, practical, modern design. Family room opens to the breakfast bar and adjoining kitchen. Two large bedrooms up and a common area upstairs could be another bedroom, game room, office or Den. This distinguished home also includes a large deck for entertaining plus yard.The Garage apartment adds a large living space one more bedroom and full bath.There is 2 car parking spots in front garage also additional parking out front.','0.1331','9','','','Electric Dryer Connections','','Sellers Disclosure','1','','0','Heights/Greater Heights','Central Gas','0','LT 13 BLK 25 NORHILL','Subdivision Lot','5800','Appraisal District','','','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','TRAVIS ELEMENTARY SCHOOL (HOUSTON)','HEIGHTS HIGH SCHOOL','HOGG MIDDLE SCHOOL (HOUSTON)','Supra Keybox','Appraisal','2','Contemporary/Modern,Traditional','Norhill','22684','2.3307','Public Sewer,Public Water','2013','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:39:13.453' ,`MLSNumber` = '81000696' ,`ListAgentFullName` = 'A. Selena Barr' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Miguel Cruz' ,`SellingOfficeName` = 'RE/MAX Prestige' ,`Latitude` = '29.986138' ,`Longitude` = '-95.606575' ,`PhotoCount` = '46' ,`PostalCode` = '77070' ,`RoomCount` = '9' ,`ListPrice` = '349900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Normont' ,`StreetNumber` = '12214' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2458' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seller PAYS BUYERS CC for accepted by NOON 10/6/22! 4 BDRM, 2 1/2 bath HOME in the well-established neighborhood of Lakewood Forest. Lots of UPDATES & NO CARPET! ALL NEW FLOORS & WINDOWS! MSTR is downstairs & has a huge, formal living room w/gas log burning ceramic logs and a beautifully remodeled useful wet-bar. The kitchen shows light and bright with pops of color and a cozy breakfast nook for enjoying the morning paper & coffee! The laundry room offers plenty of deep storage with a conveniently located yet VERY charming Powder Room! Upstairs offers a GAMEROOM with vaulted ceilings and BRAND NEW floor to ceiling windows (2021-2022) throughout the entire home and (3) more large bedrooms and FULL bathroom w/ duel sinks. Many improvements include recently replaced roof (2017) sprinkler system & controls (2017) HVAC (2020) Radiant Barrier installed in attic of Home/Garage (2020) electric panel(2020)& stunning NEW Bamboo flooring (2021) throughout! Agent Bonus' ,`Acres` = '0.2388' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 28 LAKEWOOD FOREST SEC 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '655' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Forest Sec 11' ,`TaxAmount` = '5561' ,`TaxRate` = '2.3988' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973211' WHERE `Matrix_Unique_ID` = '212995859' --> 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','213005773','1664973211','213005773','2022-10-04T22:19:02.673','42846996','Janell Callihan','Keller Williams Woodlands','','','30.694775','-95.544233','31','77340','9','158000.00','Active','Samantha','100','Lane','Huntsville','2','0','3','1764','Single-Family','Charming 3-bedroom, 2-bathroom manufactured home on a large corner lot that is centrally located near SHSU campus. Open concept living/dining/kitchen, formal dining room, breakfast area, split bedroom floor plan. Primary bedroom is extra-large and has a soaker tub, shower, double sinks and a walk-in shower. Large backyard with shade trees, extended concrete driveway/parking area. Spacious rear/side deck to sit on and enjoy the outdoors and your favorite beverage. Low taxes and close to dining, shopping, college campus, I-45, medical and more! \r\n You\'ll absolutely love Sam Houston\'s hometown of Huntsville, TX!','0.3354','43','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Huntsville Area','Central Electric','0','TIMBERLAND MANOR, LOT 1, ACRES .3354, MH LABEL# PFS0533305;','Cleared,Corner,Subdivision Lot','14610','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','64 - Huntsville','ESTELLA STEWART ELEMENTARY SCHOOL','HUNTSVILLE HIGH SCHOOL','MANCE PARK MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Other Style','Timberland Manor','1194','1.9609','Public Sewer,Public Water','2004','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T23:02:40.480' ,`MLSNumber` = '59886061' ,`ListAgentFullName` = 'Lauren Teare' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.725727' ,`Longitude` = '-95.503095' ,`PhotoCount` = '39' ,`PostalCode` = '77063' ,`RoomCount` = '8' ,`ListPrice` = '690000.00' ,`Status` = 'Active' ,`StreetName` = 'Windswept' ,`StreetNumber` = '7607' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2324' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning remodeled home in Briarmeadow w/ numerous high-end finishes. Features include an open floorplan,dbl-paned windows,hardwood floors,updated lighting. The completely remodeled kitchen features Quartzite countertops,custom wood cabinetry w/soft close hardware,Shaws farm sink,6-burner gas range+oven,and walk-in pantry.Mudroom w/custom built-in lockers for added storage space,herringbone brick floors.The family rm features a mantle w/gas log fireplace,hardwood floors+plantation shutters. The office/playroom offers custom built-in cabinetry w/Carerra marble countertop and can also function as a fourth bedroom. The gorgeous primary BR features closets w/custom Elfa built-ins and a fully remodeled bath w/Carerra marble shower+countertops,dbl sinks+more.The backyard has a custom pergola+recent concrete work w/brick edging.This home features a recent water heater(2018),recent HVAC system(2021),roof (2016),driveway gate. Briarmeadow offers a pvt pool, constable patrol+pvt trash pick-up.' ,`Acres` = '0.2169' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briarmeadow/Tanglewilde' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 22 BRIARMEADOW SEC 1 PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '730' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PINEY POINT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarmeadow Sec 01 Prcl R/P' ,`TaxAmount` = '9975' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973211' WHERE `Matrix_Unique_ID` = '213011058' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:54:07.713' ,`MLSNumber` = '45504635' ,`ListAgentFullName` = 'Madison Jones' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.789876' ,`Longitude` = '-95.198459' ,`PhotoCount` = '19' ,`PostalCode` = '77015' ,`RoomCount` = '4' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Chambly' ,`StreetNumber` = '502' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1530' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 502 Chambly Drive! Come see this 4 bedroom 2 bath home that offers a spacious living room with plenty of room for family and friends. This beautiful kitchen which opens to the dining and living room, includes all stainless appliances. Each bedroom has had the carpet replaced and a new ceiling fan installed. There is a new coat of paint inside and out as well as a roof that was recently replaced in the last 3 years. There is laminate flooring throughout the kitchen, dining, and living area with ceramic tile covering the hallway and bathrooms. The 2 car garage includes a utility closet and the back sliding glass doors lead out to a wonderful sized backyard with plenty of room to entertain. This spacious lot is located in a cul de sac and is just minutes from retail, restaurants, beltway 8 and I-10 freeway. Sold as-is.' ,`Acres` = '0.1837' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 5 RIVIERA EAST SEC 1 R/P' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'NORMANDY CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'CUNNINGHAM MIDDLE SCHOOL (GALENA PARK)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riviera East Sec 01 R/P' ,`TaxAmount` = '3934' ,`TaxRate` = '2.6774' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973211' WHERE `Matrix_Unique_ID` = '213018127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:52:15.363' ,`MLSNumber` = '73528851' ,`ListAgentFullName` = 'Cornelius Smith' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.055622' ,`Longitude` = '-95.375655' ,`PhotoCount` = '22' ,`PostalCode` = '77373' ,`RoomCount` = '8' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Baldy' ,`StreetNumber` = '2611' ,`StreetSuffix` = 'Road' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1815' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Extremely well-maintained brick ranch home situated on a cul-de-sac street with fantastic curb appeal. A wonderful kitchen with a granite countertop & an island open to the dining and family room. The smart home system allows you to see who is at the front door while cooking. Your guests will be impressed by the spectacular, high vaulted ceiling family room. Spacious and private master bedroom with a large master bathroom with double sinks with granite counter and 2 huge walk-in closets. The covered patio overlooks the huge yard with plenty of space for pets and kids to run around.' ,`Acres` = '0.1297' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 42 BLK 4 BRECKENRIDGE FOREST SEC 13' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Breckenridge Forest' ,`TaxAmount` = '5723' ,`TaxRate` = '2.8117' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973211' WHERE `Matrix_Unique_ID` = '213023486' --> 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','213032679','1664973212','213032679','2022-10-04T22:51:05.010','42335020','Jessica Giraldo','eXp Realty, LLC','','','29.986310','-95.503844','47','77069','11','325000.00','Active','Cashel Forest','14028','Drive','Houston','2','1','4','2616','Single-Family','STUNNING home In Champion Forest. FULLY Remodeled 4Bed, 2.5Bath. Only property with a private POOL and brand NEW turf installed & NEW Deck. Master down with NEW JACUZZI TUB. NEW Bathrooms, NEW Kitchen with Soft Closing Cabinets, and GORGEOUS White QUARTZ Countertops. NEW SS Whirlpool Appliances (Fridge & mini Fridge INCLUDED), NEW waterproof laminate flooring, NO CARPET! Captivating HIGH CEILING OPEN SPACE, Breakfast room and formal dining. NEW AUTO Garage door opener. NEW Fixtures (Lamps & Fans). Lawn Service Included in the HOA dues. Conveniently located near 245, 45, & Sam Houston Tollway. Shopping and dining at walking distance. NEVER FLOODED!','0.2082','13','','','Gas Dryer Connections,Washer Connections','','HOA First Right of Refusal,Mud,Sellers Disclosure','1','Freestanding,Gas Connections','1','Champions Area','Central Gas','1','TR 29A BLK 2 CHAMPIONS TERRACE SEC 1 U/R','Subdivision Lot','9069','Appraisal District','','600','0','','2','Electric Oven','1','Above Ground','','Electric Cooktop','','Composition','32 - Klein','MITTELSTADT ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','KLEB INTERMEDIATE SCHOOL','Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','2','Traditional','Champions Terrace Sec 01 U/R','4532','2.3715','Water District','1983','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:37:46.237' ,`MLSNumber` = '86787412' ,`ListAgentFullName` = 'Christopher Ward' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.974258' ,`Longitude` = '-95.515273' ,`PhotoCount` = '39' ,`PostalCode` = '77066' ,`RoomCount` = '12' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Lodge Creek' ,`StreetNumber` = '5922' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2581' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. Gorgeous curb appeal at this spacious 2 story home welcomes you home! Natural light fills the house and the family room has an electric fireplace for those chilly nights and a breakfast bar allows guests to sit and converse with the chef. The kitchen has a gorgeous Carrera Marble backsplash that compliments the Carrara Marble countertops. A grand primary bedroom features an en-suite bathroom with double sinks, a vanity, and a large walk-in closet that has additional storage space and a built-in desk. The remaining bedrooms are on the second floor for extra privacy. Take the hosting outside on the patio where guests can enjoy the beautiful weather with shade from the trees. Down the road you’ll find various grocery stores, restaurants, and a mall for all your shopping needs! Notable features include: double pane storm windows. Welcome home!' ,`Acres` = '0.2293' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 4 017*G6652900-001-004-014 GREENWOOD FOREST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9987' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'GREENWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenwood Forest Sec 01' ,`TaxAmount` = '4476' ,`TaxRate` = '2.3715' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973212' WHERE `Matrix_Unique_ID` = '213065930' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:17:28.107' ,`MLSNumber` = '29817606' ,`ListAgentFullName` = 'Theresa Riddle' ,`ListOfficeName` = 'Gusto Real Estate, LLC' ,`SellingAgentFullName` = 'Alan Stanfield' ,`SellingOfficeName` = 'Stanfield Properties' ,`Latitude` = '29.550241' ,`Longitude` = '-95.261254' ,`PhotoCount` = '22' ,`PostalCode` = '77581' ,`RoomCount` = '8' ,`ListPrice` = '290000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Dorothy' ,`StreetNumber` = '3609' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this updated home in desirable subdivision of Parkview. This spacious one-story is packed with recent upgrades. Beautiful wood like tile flooring, quartz counters in kitchen and baths, subway tile backsplash, recent stainless steel appliances. Fresh paint with trendy neutral color. Plenty of room in the den with brick fireplace and formal dining is open to kitchen with breakfast bar, breakfast room in kitchen. HUGE walk-in pantry with shelving for extra space. You will LOVE the HUGE walk-in pantry. French doors lead to Bonus FLEX room that could be game room, Home office, kids play room. Large primary bedroom. Recent 2\" blinds Near by library, Shadycrest Elementary, Independence Park, shopping and more! NO MUD taxes and No HOA.' ,`Acres` = '0.1607' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PARKVIEW SEC 1 (PEARLAND), BLOCK 9, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SHADYCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkview' ,`TaxAmount` = '5110' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973212' WHERE `Matrix_Unique_ID` = '213080820' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:14:17.960' ,`MLSNumber` = '39737899' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733468' ,`Longitude` = '-95.361628' ,`PhotoCount` = '27' ,`PostalCode` = '77004' ,`RoomCount` = '3' ,`ListPrice` = '434900.00' ,`Status` = 'Active' ,`StreetName` = 'Tuam' ,`StreetNumber` = '2502' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1730' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! Introducing Tuam Modern- including 7 single family homes in a gated community, with a contemporary modern design. These homes boast high end features including: Luxury vinyl floor, upgraded quartz countertop island, stainless steel appliances, shaker cabinets, modern glass backsplash in elegant patterned design, spacious 2nd floor living area, open concept floor-plan, and much more! Enjoy the convenient location that offers quick access to many downtown attractions and walking distance to Emancipation Park' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'BG Building Group' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 (R/P OF HOLMAN OUTLOT 24)' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`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` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Temporarily No Showings,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'TUAM SQUARE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664973212' WHERE `Matrix_Unique_ID` = '213163542' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:18:17.980' ,`MLSNumber` = '13707437' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733468' ,`Longitude` = '-95.361628' ,`PhotoCount` = '27' ,`PostalCode` = '77004' ,`RoomCount` = '3' ,`ListPrice` = '424900.00' ,`Status` = 'Active' ,`StreetName` = 'Tuam' ,`StreetNumber` = '2504' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1730' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! Introducing Tuam Modern- including 7 single family homes in a gated community, with a contemporary modern design. These homes boast high end features including: Luxury vinyl floor, upgraded quartz countertop island, stainless steel appliances, shaker cabinets, modern glass backsplash in elegant patterned design, spacious 2nd floor living area, open concept floor-plan, and much more! Enjoy the convenient location that offers quick access to many downtown attractions and walking distance to Emancipation Park' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'BG Building Group' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 (R/P OF HOLMAN OUTLOT 24)' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`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` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Controlled Access,Temporarily No Showings,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'TUAM SQUARE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664973212' WHERE `Matrix_Unique_ID` = '213184768' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:19:53.793' ,`MLSNumber` = '66899641' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733468' ,`Longitude` = '-95.361628' ,`PhotoCount` = '27' ,`PostalCode` = '77004' ,`RoomCount` = '3' ,`ListPrice` = '429900.00' ,`Status` = 'Active' ,`StreetName` = 'Tuam' ,`StreetNumber` = '2506' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1730' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! Introducing Tuam Modern- including 7 single family homes in a gated community, with a contemporary modern design. These homes boast high end features including: Luxury vinyl floor, upgraded quartz countertop island, stainless steel appliances, shaker cabinets, modern glass backsplash in elegant patterned design, spacious 2nd floor living area, open concept floor-plan, and much more! Enjoy the convenient location that offers quick access to many downtown attractions and walking distance to Emancipation Park' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'BG Building Group' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 (R/P OF HOLMAN OUTLOT 24)' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`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` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Controlled Access,Temporarily No Showings,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'TUAM SQUARE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664973212' WHERE `Matrix_Unique_ID` = '213184843' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:21:37.267' ,`MLSNumber` = '39490270' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733468' ,`Longitude` = '-95.361628' ,`PhotoCount` = '27' ,`PostalCode` = '77004' ,`RoomCount` = '3' ,`ListPrice` = '414900.00' ,`Status` = 'Active' ,`StreetName` = 'Tuam' ,`StreetNumber` = '2508' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1730' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! Introducing Tuam Modern- including 7 single family homes in a gated community, with a contemporary modern design. These homes boast high end features including: Luxury vinyl floor, upgraded quartz countertop island, stainless steel appliances, shaker cabinets, modern glass backsplash in elegant patterned design, spacious 2nd floor living area, open concept floor-plan, and much more! Enjoy the convenient location that offers quick access to many downtown attractions and walking distance to Emancipation Park' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'BG Building Group' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 (R/P OF HOLMAN OUTLOT 24)' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`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` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Controlled Access,Temporarily No Showings,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'TUAM SQUARE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664973213' WHERE `Matrix_Unique_ID` = '213184903' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:24:01.317' ,`MLSNumber` = '4948341' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733468' ,`Longitude` = '-95.361628' ,`PhotoCount` = '27' ,`PostalCode` = '77004' ,`RoomCount` = '3' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Tuam' ,`StreetNumber` = '2508' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1730' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! Introducing Tuam Modern- including 7 single family homes in a gated community, with a contemporary modern design. These homes boast high end features including: Luxury vinyl floor, upgraded quartz countertop island, stainless steel appliances, shaker cabinets, modern glass backsplash in elegant patterned design, spacious 2nd floor living area, open concept floor-plan, and much more! Enjoy the convenient location that offers quick access to many downtown attractions and walking distance to Emancipation Park' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'BG Building Group' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 (R/P OF HOLMAN OUTLOT 24)' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`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` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Controlled Access,Temporarily No Showings,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'TUAM SQUARE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664973213' WHERE `Matrix_Unique_ID` = '213185060' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:33:03.473' ,`MLSNumber` = '71136537' ,`ListAgentFullName` = 'Jhoana Olarte Vargas' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.791629' ,`Longitude` = '-95.176472' ,`PhotoCount` = '16' ,`PostalCode` = '77015' ,`RoomCount` = '9' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodforest' ,`StreetNumber` = '13934' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Investment Opportunity in the Woodforest subdivision. Charming Single-Story home, 3 bedroom, 2 bath, 2 car garage. This home is freshly painted throughout and ready to Move-in! This home features a wonderful open floor plan that makes it easy to cook and gather with family at the end of a long day. Bedrooms are generously sized and have ceiling fans. The large living area is open to the kitchen. The den could be used as a 4th bedroom or office space. Large backyard that is perfect for hosting and entertaining! Easy access to beltway 8 and I-10 East Freeway. 15 mins to Downtown and Baytown. Text \"Woodforest\" to request a video!' ,`Acres` = '0.1751' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 13 WOODFOREST SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7626' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'NORTH SHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest Sec 05' ,`TaxAmount` = '3912' ,`TaxRate` = '2.5294' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973213' WHERE `Matrix_Unique_ID` = '213204960' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:14:20.160' ,`MLSNumber` = '85087539' ,`ListAgentFullName` = 'Michelle Lee' ,`ListOfficeName` = 'KingFay Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.736487' ,`Longitude` = '-95.808300' ,`PhotoCount` = '39' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Graham Heights' ,`StreetNumber` = '4006' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3249' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful gated community property with 4-5 BED | 3.5 BATH. Next to the garage is a detached, fully furnished suite perfect for guest dwelling or other multipurpose usages. Upon entering this amazing home you\'re greeted by high ceilings & exquisite wood floors. In the heart of the home is the large living room, gourmet kitchen with a massive center island, granite counters, custom cabinetry, & SS appliances including a gas cooktop. The owner\'s retreat features a luxurious spa-like bath with separate double sinks, a deep soaking tub, a separate shower, & large walk-in closet. Covered large patio with huge backyard and no back neighbors. Zone to top rated Katy schools, Walking distance to Tompkins High School. Easy access to shopping, dining, major highways!' ,`Acres` = '0.2271' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MARSHALL OAKS SEC 1, BLOCK 1, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9894' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KILPATRICK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marshall Oaks Sec 1' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973213' WHERE `Matrix_Unique_ID` = '213249980' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T22:57:18.687' ,`MLSNumber` = '53595157' ,`ListAgentFullName` = 'DeAnna Green' ,`ListOfficeName` = 'Nydan Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.794748' ,`Longitude` = '-95.559183' ,`PhotoCount` = '25' ,`PostalCode` = '77043' ,`RoomCount` = '8' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Northbrook' ,`StreetNumber` = '10658' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1550' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home with new custom design finishes! Completely re-imagined home featuring many upgrades w/ open concept living/kitchen. Huge multi-purpose room that can be an office, study, formal living room! Kitchen has designer 42\" cabinets with gold finishing\'s. Granite countertop and tiled backsplash, SS appliances, gas cooktop w/built in oven, built-in microwave, dishwasher. New light fixtures, ceiling fans (w/remotes), and interior doors. Fresh paint inside & out, hardware, baseboards. New flooring throughout-NO carpet! Primary retreat with walk in closet. Primary bath has gorgeous vanity w/granite counter, marble finishes & seamless stand up shower! Hall bath also completely remodeled w/subway tile tub surround, vanity w/marble counter & lots of cabinetry. Close to Memorial Area and Town Center! NO FLOOD-not in floodplain!' ,`Acres` = '0.1653' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 26 BLK 4 SPRING LEA SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHADOW OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Lea Sec 01' ,`TaxAmount` = '6174' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664973213' WHERE `Matrix_Unique_ID` = '213260177' --> 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','213267192','1664973213','213267192','2022-10-04T23:41:55.960','11039068','Melanie White','RE/MAX Signature','','','29.740397','-95.600761','32','77077','9','415000.00','Active','Piping Rock','12422','Drive','Houston','2','1','4','2269','Single-Family','One of a kind updated traditional home on a quiet tree lined street at the end of a cul-de-sac in Ashford Hollow. Wonderful floor plan with 4 bedrooms, 2.5 baths, primary bedroom down and large, open living spaces. This home has been updated with marble floors, wood floors, recessed lighting, crown molding, granite, carpet, fixtures, hardware, built-ins, wet bar, gas range, solid wood double front doors with beveled glass and paint. The family room has double height ceilings and is light and bright with views to the front and also overlooks the wet bar and breakfast room. The large primary suite has vaulted ceilings and an attached primary bathroom with double sinks, private water closet and two walk-in closets. This home sits on one of the largest lots in Ashford Hollow with mature trees, sprinkler system and concrete patio area with room for a pool and covered patio. Great curb appeal with charming courtyard entryway, landscaping, water fountain and updated concrete sidewalk.','0.2953','31','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Energy Corridor','Central Gas','1','LT 63 BLK 7 ASHFORD HOLLOW SEC 1','Cul-De-Sac,Subdivision Lot','12864','Appraisal District','','450','0','','2','Electric Oven,Single Oven','0','','','Gas Range','','Composition','27 - Houston','ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL','WESTSIDE HIGH SCHOOL','WEST BRIAR MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal','2','Traditional','Ashford Hollow Sec 01','7261','2.3307','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','213273915','1664973214','213273915','2022-10-04T22:22:44.720','23124389','Jessica Salinas','RE/MAX ONE - Premier','','','30.080256','-95.479804','27','77388','10','349900.00','Active','Morgan Park','21715','Lane','Spring','3','1','4','2384','Single-Family','Beautifully landscaped two-story home offers 4 Bedrooms, 3.5 Baths & 2 car garage. This meticulously kept home welcomes you with a two-story entry, upgraded tile opening up to a formal/dining room/office/flex room with beautiful new hardwood like LVT flooring. Kitchen boasts an oversized bar area, 42” maple cabinets, tile backsplash, granite counters, black appliances & gas range. Gather together with family & friends in the breakfast area leading into the open concept family room. Relax in the primary bedroom & escape in the En Suite that includes a luxurious garden tub, separate shower, double vanity & spacious closet. Enjoy three other expansive bedrooms & game room upstairs with two additional full bathrooms. Fresh neutral paint, new hardwood like LVT flooring, new carpet, & prewired security system. Tons of storage, three large storage areas in the attic, & under the stairs. Low traffic street & a spacious backyard. Location-min. from Exxon, 99, & The Woodlands. Klein ISD Schools!','0.1218','14','KHOV','','','','Sellers Disclosure','1','','','Spring/Klein','Central Gas','1','LT 3 BLK 1 PARK AT MEADOWHILL RUN SEC 4','Subdivision Lot','5307','Appraisal District','','338','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','32 - Klein','ZWINK ELEMENTARY SCHOOL','KLEIN COLLINS HIGH SCHOOL','SCHINDEWOLF INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Park/Meadowhill Run Sec 4','6309','2.804','Public Sewer,Public Water,Water District','2014','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','213281532','1664973214','213281532','2022-10-04T22:06:11.213','78752184','Jacqui Narro','Jacqui Narro Realty','','','29.836834','-95.389348','28','77022','6','169000.00','Active','Janisch','634','Road','Houston','1','2','3','2076','Single-Family','Large home on corner lot with NO HOA - 3 bedrooms, one full bath and 2 half baths. Very large formal dining/living room, large kitchen/breakfast/living area, very large den that can be used as game room/office.','0.2259','9','','','','','No Disclosures','','','','Northwest Houston','Central Electric','0','LT 44 BLK 9 GLENBURNIE SEC 3','Subdivision Lot','9840','Appraisal District','','','0','','0','','0','','','','','Wood Shingle','27 - Houston','KENNEDY ELEMENTARY SCHOOL (HOUSTON)','WASHINGTON HIGH SCHOOL','WILLIAMS MIDDLE SCHOOL','Accompany,Appointment Required,No Supra Keybox','Appraisal District','1','Other Style','Glenburnie Sec 03','3081','2.3307','Public Sewer,Public Water','1956','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','213284716','1664973214','213284716','2022-10-04T23:02:20.390','14327194','Renae Jackson','BHGRE Gary Greene','','','29.938000','-95.234845','30','77396','6','235000.00','Active','Winter Dawn','15018','Way','Humble','2','0','3','1592','Single-Family','This beautiful 3 bedroom, 2 bath, 2 car garage home show like new. The master bedroom has 2 walk-in closets. There\'s a formal dining room currently being used as a study. You will find high ceilings, arches, niches, 2-inch blinds, black appliances and bay windows. This is a great home for any family! Location, location 101 this beauty is close to the major arteries and minutes from Bush International Airport. Don\'t miss out! It won\'t last long. Scheule your appointment toda!','0.1783','1','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Humble Area East','Central Gas','1','LT 48 BLK 2 SUNSET RIDGE WEST SEC 4','Subdivision Lot','7765','Appraisal District','','350','0','','4','Electric Oven','0','','','Gas Range','','Composition','29 - Humble','AUTUMN CREEK ELEMENTARY SCHOOL','SUMMER CREEK HIGH SCHOOL','AUTUMN RIDGE MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Sunset Ridge West','5747','3.0673','Public Sewer,Public Water,Water District','2017','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213287677','1664973214','213287677','2022-10-04T23:19:24.533','84429119','Alexis Ceasar-White','White & McCraw Realty','','','30.081905','-95.773474','19','77447','8','340000.00','Active','Indigo Robin','21202','Drive','Hockley','2','0','4','2093','Single-Family','This single story, two-toned brick home in Hockley awaits it\'s next owners! The open concept between kitchen and living room provides entertainment space with the breakfast bar inbetween. Stainless steel appliances, granite countertops as well as tile and hard floors make for easy maintenance. Primary bedroom has vaulted ceiling, his & her closets, separate tub and shower, and double sinks. Home has a large back yard and energy efficient additions.','0.1722','35','','','Electric Dryer Connections,Gas Dryer Connections','','Mud,Sellers Disclosure','1','','','Hockley','Central Gas','1','LT 1 BLK 4 BAUER LANDING SEC 6','Subdivision Lot','7499','Appraisal District','','475','0','','2','Electric Oven','0','','','Electric Range','','Composition','55 - Waller','EVELYN TURLINGTON ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','SCHULTZ JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Bauer Lndg','7453','2.8556','Water District','2019','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213297469','1664973214','213297469','2022-10-04T22:49:50.240','14833915','Darin Young','RE/MAX Universal','','','29.924858','-95.669149','50','77095','12','589999.00','Active','LYNDON MEADOWS','10302','Drive','Houston','3','1','4','3930','Single-Family','Here it is. The Home you have waited for. This GORGEOUS home in the gated community of Stone Gate. Nestled in a GOLF COURSE LOT overlooking 4th green and 5th Tee box of Private Sterling Country Club. Get ready to fall in love with ENCHANTING SUNSETS over the GOLF COURSE every evening from your very own back yard! The OPEN CONCEPT island kitchen/breakfast/living room with Blue Pearl Granite counter tops in the kitchen and island. The SPACIOUS primary bedroom w/GOLF COURSE VIEWS has PLENTY of space. New dishwasher, stove, cabinets, under mount sink, new flooring in dining and family rooms. Huge dining room. Beautiful Home/Office downstairs, Utility room connects to primary bedroom closets for easy hangup of your dress shirts, Spacious Media room upstairs connected to the Gameroom. Owner is giving a $2K carpet allowance. This Westin Home has the Westin trademark carousel staircase and shapely foyer. Open house is scheduled for this sat and sun from 12-3 October 8th and 9th.Must See!','','8','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','111','Copperfield Area','Central Electric','1','LOT 55 BLOCK 1','Cul-De-Sac,In Golf Course Community,On Golf Course,Subdivision Lot','10044','Appraisal District','','1140','0','','2','Convection Oven,Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','BIRKES ELEMENTARY SCHOOL','CYPRESS RANCH HIGH SCHOOL','SPILLANE MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal District','2','Traditional','STONE GATE','5419','2.561','Public Sewer,Public Water,Water District','2006','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213305176','1664973214','213305176','2022-10-04T22:37:51.210','64299693','Richard Blount','The Cameran Group','','','29.607807','-95.505233','32','77489','9','275000.00','Active','Chaseway','7803','Drive','Missouri City','2','0','3','2068','Single-Family','Highly desired Chasewood home is finally on the market. Beautiful corner home with estate landscaping, water sprinklers, fountains, and outstanding curb appeal. Home has a custom feel to it on a huge lot. Vaulted ceilings in formal living room with great natural lighting. Wet bar. Master has dual sinks. Huge back yard with patio and additional space for events and hosting.','0.2197','38','','','Electric Dryer Connections','','Mud','','Wood Burning Fireplace','1','Missouri City Area','Central Gas','1','CHASEWOOD R/P SEC 2, BLOCK 6, LOT 11','Corner','9569','Appraisal District','','250','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','19 - Fort Bend','E A JONES ELEMENTARY SCHOOL','MARSHALL HIGH SCHOOL (FORT BEND)','MISSOURI CITY MIDDLE SCHOOL','Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Ranch','Chasewood R/P Sec 2','3804','2.2137','Water District','1975','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213308912','1664973214','213308912','2022-10-04T22:26:16.007','44662852','Eldon Peterson','Connect Realty','','','30.160023','-94.013778','16','77662','2','135000.00','Active','Evangeline','360','Drive','Vidor','2','1','2','1838','Single-Family','Investors Special ! ! ! high and dry great location on a 1.94 acre lot. Bring this property back to life and make it a great home for you or another home buyer. Schedule your showing today.','1.94','50','','','','','Mud,Sellers Disclosure','','','1','','Central Electric','0','384 ABST. 384 W. C. SHARP, TRACT 239, ACRES 1.94','Wooded','84506','Appraisal District','','','0','','2','','0','','','','','Aluminum','1005 - Vidor','VIDOR ELEMENTARY SCHOOL','VIDOR HIGH SCHOOL','VIDOR JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','1','Ranch','OUT OF TOWN','3979','2.5489','Public Sewer,Public Water','1981','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','213309046','1664973214','213309046','2022-10-04T22:18:24.873','94747424','Zachary Davies','The Cox Company Real Estate Gr','','','30.717011','-94.932780','20','77351','3','179900.00','Active','Washington','1114','Avenue','Livingston','1','1','3','1436','Single-Family','INCREDIBLE 3 BEDROOM 2 BATH HOME IN IMMACULATE CONDITION. HARDWOOD LAMINATE FLOORING THROUGHOUT, THIS HOME WAS CONVERTED FOR A BUSINESS AND COULD EASILY SERVE AS A HOME AND OFFICE','0.395','44','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','','Livingston Area','Central Electric','0','ABST 15 M L CHOATE SURVEY SEC 2 SUB LOT 74','Cleared','17206','Appraisal District','','','0','','0','','0','','','','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','N/A','2164','1.8745','Public Sewer,Public Water,Well','1940','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213309843','1664973214','213309843','2022-10-04T23:30:13.767','38215008','Felisha Tubbs','Jammer Realty','','','29.790559','-95.145627','1','77530','6','215000.00','Active','Sheffield Terrace','15222','Drive','Channelview','2','0','3','1364','Single-Family','Cute and Cozy Home nestled in a Well-Established Neighborhood, this 3 bedroom 2 baths, 2 car garage well maintained home offers a Formal Living Area, Nice Sized Kitchen with a Breakfast areas which Opens to an Inviting Family Room. Located on a Cul-De-Sac Street and conveniently located near I-10 & Beltway 8, Close to shopping centers, schools and much more. The neighborhood has a community pool, playground area and Tennis courts.','0.1034','2','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','North Channel','Central Electric','1','LT 23 BLK 7 STERLING GREEN SOUTH SEC 6','Other','4506','Appraisal District','','250','0','','2','','0','','','Freestanding Range','','Composition','8 - Channelview','SCHOCHLER ELEMENTARY SCHOOL','CHANNELVIEW HIGH SCHOOL','JOHNSON JUNIOR HIGH','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern','Sterling Green South Sec 06','3907','2.518','Public Sewer,Water District','2000','Appraisal District'); --> New record created successfully