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'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','205619227','1668584296','205619227','2022-11-15T21:18:05.000','53772216','Sharees Bazile','Texas United Realty','','','29.687251','-95.666172','6','77083','0','300000.00','Active','Highland Brook','15926','Drive','Houston','2','1','4','2767','Single-Family','','0.1446','37','','','','','Mud,Sellers Disclosure,Short Sale','','','2','Mission Bend Area','Central Electric','1','MISSION GLEN ESTATES SEC 9, BLOCK 1, LOT 16','Subdivision Lot','6300','Appraisal District','','400','0','','2','','0','','','','','Composition','19 - Fort Bend','MISSION GLEN ELEMENTARY SCHOOL','BUSH HIGH SCHOOL','HODGES BEND MIDDLE SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Mission Glen Estates Sec 9','5350','2.2857','Water District','1998','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:54:00.577' ,`MLSNumber` = '67728067' ,`ListAgentFullName` = 'Veronica Sanchez' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Veronica Sanchez' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '30.374710' ,`Longitude` = '-94.762060' ,`PhotoCount` = '16' ,`PostalCode` = '77327' ,`RoomCount` = '3' ,`ListPrice` = '65000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Highway 146' ,`StreetNumber` = '26055' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor Special!!! Property in need of TLC- Call agent.' ,`Acres` = '0.2' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = '000064 J D MARTINEZ-1, TRACT 71, ACRES .2' ,`LotDesciption` = 'Other' ,`LotSize` = '8712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '107 - Hardin' ,`SchoolElementary` = 'HARDIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'J D Martinez-1' ,`TaxAmount` = '828' ,`TaxRate` = '1.7656' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584296' WHERE `Matrix_Unique_ID` = '208916459' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:49:56.833' ,`MLSNumber` = '5729981' ,`ListAgentFullName` = 'Lori Wilson' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.850782' ,`Longitude` = '-96.511262' ,`PhotoCount` = '36' ,`PostalCode` = '78950' ,`RoomCount` = '6' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Pinehurst' ,`StreetNumber` = '206' ,`StreetSuffix` = 'Drive' ,`City` = 'New Ulm' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2035' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Golf Course View STUNNING property located in New Ulm on an OVERSIZED LOT in the GATED COMMUNITY OF THE FALLS! 3 bedroom, 2 & a half bathroom Custom home w/ BEAUTIFUL VIEWS overlooking the golf courses 15th hole. Enjoy the lovely view off the spacious deck shaded by huge oak trees. Home Features OPEN FLOOR PLAN, LARGE family room, wood burning fireplace, breakfast area, dining area or additional seating space, dry bar area, alarm system & more. Updated bathrooms, lighting fixtures and leathered granite countertops throughout. Kitchen boasts Updated Stainless Steel appliances, farmhouse sink, granite and subway tile backsplash. Beautiful Recently Added guest bath w/ modern shiplap off the large laundry room. New WINDOWS throughout! Enjoy evenings out by the FIRE-PIT. 4 yr old Roof, Leaf guard gutters,Sprinkler System. Great location if you want the COUNTRY FEEL or to get out to the Country just a short 20 minutes to Columbus or 45 min. to Katy.Need a WEEKEND RETREAT This could be yours!' ,`Acres` = '0.338' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLK 1 LT 5A, PT 4A THE FALLS REPLAT SEC II & HOUSE' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Wooded' ,`LotSize` = '14700' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '188 - Columbus' ,`SchoolElementary` = 'COLUMBUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLUMBUS HIGH SCHOOL' ,`SchoolMiddle` = 'COLUMBUS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Falls' ,`TaxAmount` = '4802' ,`TaxRate` = '2.0459' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584297' WHERE `Matrix_Unique_ID` = '209836570' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:18:25.590' ,`MLSNumber` = '15757264' ,`ListAgentFullName` = 'Glendi Ramos' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.632355' ,`Longitude` = '-95.423160' ,`PhotoCount` = '13' ,`PostalCode` = '77045' ,`RoomCount` = '6' ,`ListPrice` = '189900.00' ,`Status` = 'Active' ,`StreetName` = 'Trail Lake' ,`StreetNumber` = '3115' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1293' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great started home. This house has been very well take care of . Enjoy family get-togethers in a private huge backyard\r\nNo HOA, According to seller A/C units is 6 years old ,home never flooded .\r\nMeasurements are approximately buyer to verify all the information.\r\nSchedule your appointment today!' ,`Acres` = '0.1205' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BLK 6 GLEN IRIS SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HOBBY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glen Iris Sec 01' ,`TaxAmount` = '2471' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584297' WHERE `Matrix_Unique_ID` = '210535378' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:56:07.480' ,`MLSNumber` = '34930762' ,`ListAgentFullName` = 'Roxanna Plazas' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.876443' ,`Longitude` = '-95.733584' ,`PhotoCount` = '26' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Southern Colony' ,`StreetNumber` = '21131' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1452' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 1 SETTLERS VILLAGE SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Settlers Village Sec 01 R/P' ,`TaxAmount` = '4531' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584297' WHERE `Matrix_Unique_ID` = '211014034' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:23:04.837' ,`MLSNumber` = '45870714' ,`ListAgentFullName` = 'Holly Dool' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = 'Cassie Dieudonne' ,`SellingOfficeName` = 'FYI Realty-Katy' ,`Latitude` = '29.768050' ,`Longitude` = '-95.735912' ,`PhotoCount` = '26' ,`PostalCode` = '77450' ,`RoomCount` = '9' ,`ListPrice` = '339900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Park Royale' ,`StreetNumber` = '1211' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2421' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely four-bedroom home on cul-de-sac on beautiful street in great location in Katy\'s well established Memorial Parkway subdivision. Nice and quiet place to live. Very nice open floor plan with abundant storage and spacious rooms with hardwood floors tile and carpet. Granite countertops and stainless steel appliances, fridge included, nice fireplace. Large master down, 3 bedrooms up. Features large garage w/ epoxy floor and fenced back yard. Low tax rate! Zoned to great Katy ISD schools. Community pool, tennis courts and 2 parks with swing sets, play areas, pavilions and more. Close to Bike Trails that lead all way to Beltway 8. Easy access to major thoroughfares- minutes to I-10 and Grand Parkway 99, close to shopping and restaurants. HEB just around the corner! Close to Park and Ride.' ,`Acres` = '0.2003' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 47 BLK 14 MEMORIAL PARKWAY SEC 6 R/P' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8724' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MEMORIAL PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MEMORIAL PARKWAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Pkwy Sec 06 R/P' ,`TaxAmount` = '5730' ,`TaxRate` = '2.3283' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584297' WHERE `Matrix_Unique_ID` = '211089143' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:08:36.760' ,`MLSNumber` = '52350208' ,`ListAgentFullName` = 'Andrea Rodriguez' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.743385' ,`Longitude` = '-95.581293' ,`PhotoCount` = '22' ,`PostalCode` = '77077' ,`RoomCount` = '11' ,`ListPrice` = '339500.00' ,`Status` = 'Active' ,`StreetName` = 'Woodland Springs' ,`StreetNumber` = '2126' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2397' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful ranch style home in the Energy Corridor with a brand new kitchen, brand new driveway, open concept, high ceilings, new storm windows, and an upstairs loft. Enter an inviting residence showcasing bright and airy spaces, 4 bedrooms allowing the option for a study or studio, as well as 1 primary bath and 1 other full bath. Amazing outdoor living encompasses a gated entrance, front patio area, back patio area, and a paved walkway perfect for gardening. Enjoy the neighborhood pool, playground & clubhouse amenities plus minutes to Terry Hershey Park, Buffalo Bayou, Lakeside Country Club, shops, restaurants & City Center. With easy access to I-10, Beltway 8 & 610 Loop. Buyers could no longer purchase home. Back on the market!' ,`Acres` = '0.1446' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 3 APRIL VILLAGE SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '510' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASKEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'April Village Sec 01' ,`TaxAmount` = '6226' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584297' WHERE `Matrix_Unique_ID` = '211999012' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:43:25.597' ,`MLSNumber` = '62338311' ,`ListAgentFullName` = 'Tina Langford' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.547697' ,`Longitude` = '-95.056944' ,`PhotoCount` = '40' ,`PostalCode` = '77565' ,`RoomCount` = '8' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Dillonwood' ,`StreetNumber` = '2086' ,`StreetSuffix` = 'Court' ,`City` = 'Kemah' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3308' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Sellers! Possible paint concession. Furniture can stay--also negotiable! The grand entrance with wrought iron double doors lead into the elegant foyer, featuring a wrought iron staircase. The primary bedroom is downstairs with 3 secondary bedrooms, a game room, and fully equipped media room upstairs. The office and formal dining open to the living room, kitchen, and breakfast area. The kitchen is spacious and features an island and granite countertops. Whether you enjoy entertaining or relaxing, the back yard oasis is a tropical dream! Take a dip in the saltwater pool or relax in the Strongspa jacuzzi. Invite friends and family to lounge under the gazebo with ceiling fan, surrounded by a bamboo fence with tiki lights. Must see to believe!!' ,`Acres` = '0.1481' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TWIN OAKS SUB SEC 2 (2007) ABST 18, BLOCK 1, LOT 11' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6451' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Twin Oaks Sub Sec 2 2007' ,`TaxAmount` = '7961' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584298' WHERE `Matrix_Unique_ID` = '212156432' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:49:18.537' ,`MLSNumber` = '2841614' ,`ListAgentFullName` = 'Angel Rupert' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842166' ,`Longitude` = '-95.481226' ,`PhotoCount` = '39' ,`PostalCode` = '77092' ,`RoomCount` = '7' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Rena' ,`StreetNumber` = '6011' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Magnificently Renovated One-Level Home in Central Northwest Houston! Nestled on a 7,919sqft lot only steps to Clifton Middle School and Forest West Park, this 4BR/2BA, 2,008sqft residence delightfully charms with a classic Texan brick exterior and a manicured lawn. Newly updated for universal appeal, the fabulous interior dazzles with gorgeous faux wood flooring, a modern color palette, an openly flowing floorplan, and a spacious living room with a stone corner fireplace, a wood ceiling beam, and vaulted ceilings. Catering to gourmets, the upgraded kitchen features granite countertops, white shaker cabinetry, double wall ovens, glass cooktop, subway tile backsplash, and a breakfast nook. Bask in the oversized primary bedroom with ample closet space and an attached en suite boasting a chic barndoor. Three additional bedrooms are sized for accommodating comfort. Other features: 2-car garage, laundry area, never flooded, near shops, dining, and schools, and more! Schedule your tour today!' ,`Acres` = '0.1818' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 620 BLK 20 FOREST WEST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '197' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest West Sec 02' ,`TaxAmount` = '5837' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584298' WHERE `Matrix_Unique_ID` = '212183086' --> 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','212422961','1668584298','212422961','2022-11-15T21:34:43.837','94134485','Michael Ifland','Cityscape Brokers','','','29.650282','-95.212741','20','77034','8','200000.00','Active','Empress','231','Drive','Houston','2','0','3','1651','Single-Family','Charming 3 bed 2 bath one story home with a large fenced backyard. This home features both formal living and formal dining! Spacious family room with double doors to the large covered back patio. Breakfast room is conveniently located near kitchen. Primary bedroom with en suite bath. Kitchen complete with dishwasher, microwave and stainless steel refrigerator. Spacious fully fenced backyard is the perfect place to enjoy BBQs, parties and more! Great location near shopping and restaurants and I-45 Gulf Freeway for an easy commute.','0.1836','3','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Hobby Area','Central Gas','0','LT 40 BLK 1 ARLINGTON HEIGHTS SEC 1','Subdivision Lot','7996','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','41 - Pasadena','PEARL HALL ELEMENTARY SCHOOL','SOUTH HOUSTON HIGH SCHOOL','MILLER INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Arlington Heights','3947','2.6863','Public Sewer,Public Water','1960','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:04:06.037' ,`MLSNumber` = '89388376' ,`ListAgentFullName` = 'Kelley Clark' ,`ListOfficeName` = 'Realty One Group Optima' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.762533' ,`Longitude` = '-95.877791' ,`PhotoCount` = '44' ,`PostalCode` = '77494' ,`RoomCount` = '5' ,`ListPrice` = '537500.00' ,`Status` = 'Active' ,`StreetName` = 'Orchard Berry' ,`StreetNumber` = '1931' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3223' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DON\'T WAIT TO BUILD! Here is the property you\'ve been looking for! This forever home features 5 beds, 4 baths, open concept with amazing floor plan, high ceilings and 8 foot doors to make the whole house feel grand. The oversized backyard has so much potential with an extended patio plumbed for your custom outdoor kitchen. You can easily imagine the pool and firepit to enjoy those Texas sunsets. The utility room is located next to the garage entrance and attached to the primary suite to create a unique and handy walk through. The 3-car garage is something to talk about! Not only does it have plenty of space for a workbench area, but it includes extra built-in storage above the garage doors for all of your holiday decor! Speaking of storage, did you see the extended granite countertops and cabinets in the spacious kitchen? Upstairs has a spacious game room and a cozy media room for those Friday movie nights. Don\'t wait to see this dream home!' ,`Acres` = '0.3371' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'YOUNG RANCH SEC 4, BLOCK 2, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14683' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double 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,Leave Business Card,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Young Ranch Sec 4' ,`TaxAmount` = '11231' ,`TaxRate` = '3.072' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668584298' WHERE `Matrix_Unique_ID` = '212921448' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:14:19.867' ,`MLSNumber` = '25314445' ,`ListAgentFullName` = 'Ebonee Bledsoe' ,`ListOfficeName` = 'Glass House Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.668572' ,`Longitude` = '-95.424132' ,`PhotoCount` = '26' ,`PostalCode` = '77054' ,`RoomCount` = '12' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Grand Fountains' ,`StreetNumber` = '2812' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful home located in the inner city living with a quiet neighborhood feel. This gated community is conveniently located with easy access to the Texas Medical Center, Houston Zoo, and Hermann Park! This home features a modern open concept, beautiful hardwood flooring , and stainless steel appliances. First floor bedroom is perfect for a play room, office, workout room, or guest suite. Primary includes a dual vanity, standing frameless shower, spa bath, and his & hers closets. Off the second floor is a spacious outdoor patio facing the community pool, also great for entertaining with room for seating and a grill. On the front porch is an innovative delivery closet to keep your packages secure all day. The community also features a luxurious resort style pool and pool house where you can gather with friends and interact with your neighbors. As well as a private dog park. So that your pets can make friends too!' ,`Acres` = '0.0346' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1 BUFFALO POINTE' ,`LotDesciption` = 'Other' ,`LotSize` = '1508' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHEARN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Buffalo Pointe' ,`TaxAmount` = '10421' ,`TaxRate` = '2.8807' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1668584298' WHERE `Matrix_Unique_ID` = '212994724' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:54:28.653' ,`MLSNumber` = '15819944' ,`ListAgentFullName` = 'Alejandro Carrillo' ,`ListOfficeName` = 'Fratelli Properties International' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.150848' ,`Longitude` = '-95.652247' ,`PhotoCount` = '50' ,`PostalCode` = '77362' ,`RoomCount` = '10' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Hillside' ,`StreetNumber` = '33603' ,`StreetSuffix` = 'Drive' ,`City` = 'Pinehurst' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2171' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated in the fabulous Britwood Estates, this one story, 4 bedrooms and 2 baths home will impress you from the moment you arrive! Step inside and be greeted by the formal dining room area. Open design kitchen is equipped with stainless steel appliances, gas cooktop, gorgeous bold cabinets, & granite countertops. The kitchen overlooks the family room for an open concept. Live in a quiet, private, country setting without the hassles of big city living. This is your opportunity. This property has 1.5 acres fully fenced with lots of privacy. Backdoor leads out to the sprawling covered patio, enjoy outdoor entertaining and warm summer nights! Super low tax rate, not in the flood zone and is ready for a new owner to call home.' ,`Acres` = '1.5181' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'BRITWOOD ESTATES, BLOCK 1, LOT 1, ACRES 1.5181' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '66128' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Britwood Estates' ,`TaxAmount` = '3522' ,`TaxRate` = '1.9215' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584299' WHERE `Matrix_Unique_ID` = '213016107' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:29:13.143' ,`MLSNumber` = '63272289' ,`ListAgentFullName` = 'Sammy Younis' ,`ListOfficeName` = 'RE/MAX Southwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.532121' ,`Longitude` = '-95.568623' ,`PhotoCount` = '37' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '790000.00' ,`Status` = 'Active' ,`StreetName` = 'Dexter Bluff' ,`StreetNumber` = '6411' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4293' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS 1.5-STORY HOME SITUATED ON A QUIET CUL-DE-SAC IN THE MASTER-PLANNED COMMUNITY OF RIVERSTONE! THIS SPECTACULAR STUCCO HOME WILL IMPRESS FROM THE MOMENT YOU ARRIVE - FROM THE BEAUTIFUL FRONT STUCCO ELEVATION TO THE PRIVATE BACKYARD OASIS WITH A POOL AND NO REAR NEIGHBORS FOR ADDED PRIVACY TO THE 3-CAR GARAGE. TERRIFIC FLOOR PLAN WITH 4 BEDROOMS DOWN PLUS SEPARATE STUDY THAT COULD ALSO BE A FORMAL LIVING ROOM. AN OVERSIZED FAMILY ROOM WITH A FIREPLACE OPENS UP TO A GOURMET KITCHEN WITH CUSTOM CABINETRY AND HIGH-END COUNTERTOPS. UPSTAIRS FEATURES A LARGE GAMEROOM PLUS A FULL BATHROOM AND CLOSET IN CASE SOMEONE NEEDED A 5TH BEDROOM. OUTDOOR OASIS WITH LARGE COVERED PATIO, POOL WITH TRAVERTINE DECKING AND SEPARATE HOT TUB ALL SURROUND BY LUSH LANDSCAPING AND FRUIT TREES. THE POOL IS FENCED FOR LITTLE ONES, BUT THE FENCE COULD BE REMOVED. TERRIFIC FORT BEND SCHOOLS! PRICED TO SELL!! CALL THE AIDA YOUNIS TEAM TODAY!' ,`Acres` = '0.2857' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'THE ORCHARD AT RIVERSTONE SEC 3, BLOCK 2, LOT 4' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12444' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Riverstone' ,`TaxAmount` = '10340' ,`TaxRate` = '2.6729' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584299' WHERE `Matrix_Unique_ID` = '213078645' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:40:11.820' ,`MLSNumber` = '66221188' ,`ListAgentFullName` = 'Jessica Wiley' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = 'Jessica Wiley' ,`SellingOfficeName` = 'CB&A, Realtors' ,`Latitude` = '30.200120' ,`Longitude` = '-95.624767' ,`PhotoCount` = '24' ,`PostalCode` = '77354' ,`RoomCount` = '4' ,`ListPrice` = '299999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hilltop Prairie' ,`StreetNumber` = '40320' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1817' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable barely lived in one story home with a massive pool worthy backyard with NO REAR NEIGHBORS. This open-concept home features 4 bedrooms (primary bedroom is away from spare bedrooms), 2 bathrooms, breakfast bar, spacious dining area, large covered back patio, full gutters and sprinkler system in front and back yard! \r\nSellers are leaving the BRAND NEW Washer, Dryer and Refrigerator!\r\nWhy wait to build when you can live here NOW!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DR HORTON' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Mill Creek Estates 03, Block 4, Lot 10' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '8113' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek' ,`TaxAmount` = '' ,`TaxRate` = '3.2087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668584299' WHERE `Matrix_Unique_ID` = '213170210' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:42:09.813' ,`MLSNumber` = '74003552' ,`ListAgentFullName` = 'Gabriela Sanches' ,`ListOfficeName` = 'RCR Properties Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.561832' ,`Longitude` = '-95.816805' ,`PhotoCount` = '33' ,`PostalCode` = '77471' ,`RoomCount` = '6' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Walnut' ,`StreetNumber` = '1103' ,`StreetSuffix` = 'Avenue' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1024' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this magnificent home on Riverside Terrace, which has 4 bedrooms and 2 bathrooms. There is now a fourth room, which was formerly the garage. Browse out the garden view from such a lovely home\'s spacious front and backyard. There are several canopy shade just on property for additional shade. The parking was extended with-concrete through out the outside of home . When you come the first thing you’ll see a elegant style steel front door gate that provides privacy. LOW TAXES and NO HOA. Stores are near area. Accessible highways. Behind home there is an additional laminated storage building washer and dryer connections are in this shed. Take a look at this beautiful garden with palm trees near entrance gate. Quiet neighborhood. Make you’re appointment today! ' ,`Acres` = '0.1377' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'RIVERSIDE TERRACE SEC 1, BLOCK 2, LOT 24 & 25' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'JACKSON ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverside Terrace Sec 1' ,`TaxAmount` = '1444' ,`TaxRate` = '2.0748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584299' WHERE `Matrix_Unique_ID` = '213405256' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:08:27.277' ,`MLSNumber` = '63044138' ,`ListAgentFullName` = 'Tamatha Mayfield' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.164792' ,`Longitude` = '-95.293896' ,`PhotoCount` = '26' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '284999.00' ,`Status` = 'Active' ,`StreetName` = 'Timbermill' ,`StreetNumber` = '18357' ,`StreetSuffix` = 'Lane' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1880' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one-story home in New Caney located in the Porters Mill community. This 4-bedroom, 2-bath home is Smart Home ready with a beautiful open floor plan. You have upgraded features like a complete sprinkler system front and back, granite countertops in the kitchen with endless hot water with your tankless water heater in the garage. Relax after a long day in your huge master bedroom with a gorgeous master bathroom featuring double sinks, a separate bathtub, a standing shower, and a massive walk-in closet. Enjoy your backyard on your covered patio on those beautiful days out back after a long day. The community features a beautiful neighborhood pool with a splash pad area with lifeguards onsite and a playground. You are within close proximity to local grocery stores, shopping centers, and restaurants!' ,`Acres` = '0.1382' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S812702 - PORTERS MILL 02, BLOCK 4, LOT 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Porters Mill 02' ,`TaxAmount` = '6324' ,`TaxRate` = '3.0331' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584299' WHERE `Matrix_Unique_ID` = '213447151' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:25:09.650' ,`MLSNumber` = '48746192' ,`ListAgentFullName` = 'Ava Sempe' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.088411' ,`Longitude` = '-96.067124' ,`PhotoCount` = '23' ,`PostalCode` = '77445' ,`RoomCount` = '6' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Cemetary' ,`StreetNumber` = '1719' ,`StreetSuffix` = '' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW Custom Construction - Welcome home to the serine countryside - overlooking a BEAUTIFUL horse ranch in the City of Hempstead. Home will have Stone Elevation w/Cement board siding w/Covered Front Porch. Open floorplan with Kitchen/Dining overlooking Family Room. 3 Spacious bedrooms, 2 full baths and a Covered Porch to enjoy your evening outdoors. CITY UTILITIES, NO HOA, LOW TAXES! EZ Access to Hwy 290 and to the City Amenities that include: Walking Track, Splashpad, Baseball Fields, Basketball Courts, Sand Volleyball and Playgrounds. Buyer/Agent to verify all measurements and/or information. *Price subject to change.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Hempstead Premier Ho' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 7, Block 417 City of Hempstead' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'City of Hempstead' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668584300' WHERE `Matrix_Unique_ID` = '213560099' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:27:11.187' ,`MLSNumber` = '11422983' ,`ListAgentFullName` = 'Ava Sempe' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.088228' ,`Longitude` = '-96.067118' ,`PhotoCount` = '28' ,`PostalCode` = '77445' ,`RoomCount` = '7' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Cemetary' ,`StreetNumber` = '1739' ,`StreetSuffix` = '' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW Custom Construction - Estimated Completion by the end of December!!!Welcome home to the serine countryside - overlooking a BEAUTIFUL horse ranch in the City of Hempstead. Home will have Stone Elevation w/Cement board siding w/Covered Front Porch. Open floorplan with Kitchen/Dining overlooking Family Room. 3 Spacious bedrooms, 2 full baths and a Large Covered Porch to enjoy your evening outdoors. CITY UTILITIES, NO HOA, LOW TAXES! EZ Access to Hwy 290 and to the City Amenities that include: Walking Track, Splashpad, Baseball Fields, Basketball Courts, Sand Volleyball and Playgrounds. Buyer/Agent to verify all measurements and/or information. *Price subject to change.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Hempstead Premier Ho' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 9, BLK 417 City of Hempstead' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'City of Hempstead' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668584300' WHERE `Matrix_Unique_ID` = '213560848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:25:47.853' ,`MLSNumber` = '69410775' ,`ListAgentFullName` = 'Ava Sempe' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.088320' ,`Longitude` = '-96.067121' ,`PhotoCount` = '27' ,`PostalCode` = '77445' ,`RoomCount` = '6' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Cemetary' ,`StreetNumber` = '1729' ,`StreetSuffix` = '' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW Custom Construction - Estimated Completion- End of December! Welcome home to the serine countryside - overlooking a BEAUTIFUL horse ranch in the City of Hempstead. Home will have Stone Elevation w/Cement board siding w/Covered Front Porch. Open floorplan with Kitchen/Dining overlooking Family Room. 3 Spacious bedrooms, 2 full baths and a Covered Porch to enjoy your evening outdoors. CITY UTILITIES, NO HOA, LOW TAXES! EZ Access to Hwy 290 and to the City Amenities that include: Walking Track, Splashpad, Baseball Fields, Basketball Courts, Sand Volleyball and Playgrounds. Buyer/Agent to verify all measurements and/or information. *Price subject to change.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Hempstead Premier Ho' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 7, Block 417 City of Hempstead' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'City of Hempstead' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668584300' WHERE `Matrix_Unique_ID` = '213561212' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:57:22.933' ,`MLSNumber` = '31368221' ,`ListAgentFullName` = 'Dawn Faust' ,`ListOfficeName` = 'Flat Fee Discount Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.289472' ,`Longitude` = '-94.801181' ,`PhotoCount` = '35' ,`PostalCode` = '77550' ,`RoomCount` = '7' ,`ListPrice` = '325700.00' ,`Status` = 'Active' ,`StreetName` = '33rd' ,`StreetNumber` = '1811' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Craftsman Raised Bungalow Remodeled 2/1/1, Refinished hardwood floors throughout except for bathroom and kitchen. Remodeled bath has new porcelain tile on floor and in shower/bath surround with stone inlay accents. Remodeled kitchen has porcelain tiles on floor, farmhouse sink, original all wood cabinets with glass front upper cabinets to preserve the craftsman feel of the kitchen. New countertops have brought a natural, but artistic feel with black walnut live edge boards and a 6 color epoxy pour that brings the feel of our island and coastal beachfront to the kitchen. Spacious downstairs allows for a laundry area, workshop and plenty of storage area. 1\r\ncar garage provides enough room for a car or golf cart. Newly constructed outside deck for relaxing in the shaded backyard with newly landscaped yard. Rainwater catch system tied into gutters on garage with large storage tank. Centrally located, close to Strand district, UTMB, TAMUG, GC. Walk to Beach & Mardi Gras Parades.' ,`Acres` = '0.059' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric,Central Gas,Other Heating,Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR N 15 FT OF LOTS 8,9 & S 15 FT OF ADJ' ,`LotDesciption` = 'Other' ,`LotSize` = '2570' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '2655' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584300' WHERE `Matrix_Unique_ID` = '213687238' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:07:52.967' ,`MLSNumber` = '54123147' ,`ListAgentFullName` = 'Zach Toth' ,`ListOfficeName` = 'Sprout Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.023667' ,`Longitude` = '-95.752819' ,`PhotoCount` = '50' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'Bowdin Crest' ,`StreetNumber` = '17202' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4926' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home is located just minutes away from the Houston Premium Outlet Mall, fine dining, and is in close proximity to major highways; 99 and 290. In addition, this home is zoned to the highly accredited Cypress Fairbanks ISD. This spacious home sits on a large lot, just shy of 3/4 of an acre, and backs up to the neighborhood greenbelt (as well as a fully stocked pond with a water feature). No stone was left unturned in this backyard paradise! Some of its features include a huge 3 lane lap pool, a hot tub, fire pit, LED lighting, outdoor speakers, pergola with a motorized roof to allow the sun in or keep you out of the elements, mosquito misting system and a fully lit sports court. Off the back of the garage you will enjoy a 650 sq/ft air conditioned pool house equipped with a fully functional mini kitchen, a bathroom with a walk-in shower and a unique glass garage door that overlooks the sport court. This 5 BR home has so much to offer. Schedule your showing today!' ,`Acres` = '0.6715' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 76 BLK 1 LAKES OF FAIRHAVEN SEC 1' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '29250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SWENKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Fairhaven' ,`TaxAmount` = '15454' ,`TaxRate` = '2.2317' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584301' WHERE `Matrix_Unique_ID` = '213724721' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:07:01.060' ,`MLSNumber` = '31502495' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.700218' ,`Longitude` = '-95.873959' ,`PhotoCount` = '44' ,`PostalCode` = '77441' ,`RoomCount` = '12' ,`ListPrice` = '1300000.00' ,`Status` = 'Active' ,`StreetName` = 'Walton Water Way' ,`StreetNumber` = '123' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5185' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous custom Kickerello home situated within the gated section of Cross Creek Ranch. Upon entering you will be captivated by the soaring ceilings, an open luxurious living room, and floor-to-ceiling windows across the back of the home. The gourmet kitchen has beautiful wood cabinetry, granite countertops, SS Wolf appliances, and an oversized center island. The adjacent family room is perfect for relaxing or entertaining while taking in that spectacular view. Prepare to fall in love with the Owner\'s Suite featuring tall tray ceilings, floor-to-ceiling windows (there\'s that view again), and an en-suite bath with dual sinks, soaking tub, and 2 spacious closets. Upstairs you will find 3 bedrooms, 2 baths, and a Gameroom with access to an expansive balcony and sitting area. Following the stairs down from your balcony, you enter your very own private backyard paradise complete with jaw-dropping views of the majestic lake and fountain, pool, spa, half bath, shower, and outdoor kitchen.' ,`Acres` = '0.2879' ,`Area` = '30' ,`BuilderName` = 'Kickerillo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF CROSS CREEK RANCH SEC 2, BLOCK 2, LOT 11' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '12539' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Lakes Of Cross Creek Ranch Sec 2' ,`TaxAmount` = '25529' ,`TaxRate` = '3.3362' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584301' WHERE `Matrix_Unique_ID` = '213737488' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:57:29.250' ,`MLSNumber` = '91503318' ,`ListAgentFullName` = 'Debra Shelly' ,`ListOfficeName` = 'Westchase Realty Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.595340' ,`Longitude` = '-95.501030' ,`PhotoCount` = '29' ,`PostalCode` = '77489' ,`RoomCount` = '5' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Gatebriar' ,`StreetNumber` = '15838' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1246' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Major Price Improvement. Very motivated seller. Single family property; NOT a duplex, with large bedrooms and upgraded bathrooms and no carpeting. Master bedroom has his and her closets and remodeled bathroom with new tile, bathtub and sink. Master bedroom designer ceramic flooring. Secondary bedroom has a large walk in closet. Another bedroom can be added to the secondary bedroom. Secondary bathroom has new bathtub, tile and sink. Kitchen has all electrical appliances, new tiled floors and new stove. Kitchen has ample space for cooking. All plumbing replaced with PEX pipes per Seller. New garage door installed. Beautiful front and back yards. No MUD taxes. Lower interest rates available with select lenders. Call for details.' ,`Acres` = '0.1566' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BRIARGATE SEC 8, BLOCK 11, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BRIARGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briargate Sec 8' ,`TaxAmount` = '3071' ,`TaxRate` = '2.2137' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584301' WHERE `Matrix_Unique_ID` = '213800813' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:27:13.013' ,`MLSNumber` = '47788004' ,`ListAgentFullName` = 'Pam Kelley' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.648866' ,`Longitude` = '-95.624566' ,`PhotoCount` = '21' ,`PostalCode` = '77498' ,`RoomCount` = '6' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenbriar' ,`StreetNumber` = '13627' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1210' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property is located in a very desirable, well established neighborhood in the city limits of Sugar Land. Kitchen and baths were updated within the last 4 years. Appliances were updated as well. 3 bedrooms, 2 baths and a 2 car garage. Double doors lead to a nice size yard with a storage shed/Work shop. Laminate flooring and carpet in the bedrooms, tile in the wet areas. Nice trees in yard for shade. Needs some TLC. No MUD tax. No active HOA! Fort Bend ISD. Close to freeways & shopping.' ,`Acres` = '0.1515' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'GREENBRIAR ADDN, BLOCK 4, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`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` = '19 - Fort Bend' ,`SchoolElementary` = 'BARRINGTON PLACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Greenbriar Add' ,`TaxAmount` = '3049' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584301' WHERE `Matrix_Unique_ID` = '213802017' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:06:57.860' ,`MLSNumber` = '90993443' ,`ListAgentFullName` = 'Manuel Larios' ,`ListOfficeName` = 'Exceed Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842035' ,`Longitude` = '-95.483622' ,`PhotoCount` = '20' ,`PostalCode` = '77092' ,`RoomCount` = '7' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Leaf Arbor' ,`StreetNumber` = '6227' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 4 bedroom/2 bath home in a tranquil neighborhood with great access to Hwy. 290, restaurants, city library, and shopping. Master bath comes with a large walk-in shower, huge backyard, neighborhood pool and elementary school in walking distance. Price to sell. AS-IS' ,`Acres` = '0.1485' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 598 BLK 19 FOREST WEST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6470' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest West Sec 02' ,`TaxAmount` = '5205' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584301' WHERE `Matrix_Unique_ID` = '213857606' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:34:04.153' ,`MLSNumber` = '78621639' ,`ListAgentFullName` = 'Jennifer Lowe' ,`ListOfficeName` = 'RE/MAX 1st Team' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.161731' ,`Longitude` = '-95.421135' ,`PhotoCount` = '23' ,`PostalCode` = '77515' ,`RoomCount` = '7' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Evans' ,`StreetNumber` = '401' ,`StreetSuffix` = 'Street' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1816' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '$3,000 in Seller Concessions! This beautiful 4 bedroom 2 bathroom home is located in the heart of Angleton close to shopping and dining. Recent paint inside and outside of the home. The kitchen has granite countertops and stainless steel appliances there is also a large pantry area and indoor laundry area. There is a large oversized den/living room at the back of the home. Lots of space in this home for everyone to enjoy. Outside you will enjoy the large back yard with mature trees for shade. This home has solar panels installed to reduce your electricity bill. Make your appointment today to see the fabulous home in person.' ,`Acres` = '0.186' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MCCORMACK (ANGLETON) BLK 3 LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8102' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Mccormack Angleton' ,`TaxAmount` = '4531' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584302' WHERE `Matrix_Unique_ID` = '214038633' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:06:38.347' ,`MLSNumber` = '63480107' ,`ListAgentFullName` = 'Elizabeth Rodriguez' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.873716' ,`Longitude` = '-95.631673' ,`PhotoCount` = '35' ,`PostalCode` = '77084' ,`RoomCount` = '7' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Hearth' ,`StreetNumber` = '14919' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Stunning home is located in Hearth Stone place subdivision, Conveniently located near Farm to Market 1960 Rd, easy access to beltway 8 and Hwy 290. Home was fully remodeled in 2018, patio was added in 2021, A/C installed in 2015 and New roof in 2016. Check out all the oversize bedrooms and the Huge master bedroom very rare to find. Can\'t forget the large kitchen to do all your cooking and the large covered patio to enjoy during those hot sunny days. Don\'t miss out on this house, Book your showing today!' ,`Acres` = '0.1205' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 2 HEARTHSTONE PLACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '387' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hearthstone Place Sec 01' ,`TaxAmount` = '6592' ,`TaxRate` = '3.171' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584302' WHERE `Matrix_Unique_ID` = '214067231' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:05:25.797' ,`MLSNumber` = '20327692' ,`ListAgentFullName` = 'Leslie Free' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.015101' ,`Longitude` = '-95.178496' ,`PhotoCount` = '40' ,`PostalCode` = '77346' ,`RoomCount` = '11' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenfield' ,`StreetNumber` = '20819' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2723' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This wonderful home can be yours just in time for the holidays! You\'ll love walking into this inviting 2 story Foyer with an open Formal Dining room to the left & a Study/Office with French doors for privacy to the right. The large Family room is open to Kitchen & Breakfast room, all with great views of the backyard & pool too! The Primary bedroom & bathroom are spacious & has double vanities, a separate shower, tub & 2 walk-in closets. Located on the second floor is a game room, 3 secondary bedrooms & a full bathroom. The backyard has plenty of green space, a new deck & back fence. Roof was replaced in August 2022, water heater 2016, exterior paint & AC/compressor 2018. Conveniently located close to Lake Houston, San Jacinto River, greenbelts, pool, parks, shopping & restaurants! Has never flooded.' ,`Acres` = '0.1701' ,`Area` = '1' ,`BuilderName` = 'Village' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 3 KINGS RIVER VILLAGE SEC 2' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '7408' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings River Village' ,`TaxAmount` = '6832' ,`TaxRate` = '2.453' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584302' WHERE `Matrix_Unique_ID` = '214067767' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:38:34.370' ,`MLSNumber` = '8734479' ,`ListAgentFullName` = 'Joshua Haynie' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.370503' ,`Longitude` = '-95.584034' ,`PhotoCount` = '33' ,`PostalCode` = '77356' ,`RoomCount` = '7' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Regency' ,`StreetNumber` = '65' ,`StreetSuffix` = 'Point' ,`City` = 'Conroe' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1294' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is where your dreams come true! Lake living at its finest on extremely sought-after Lake Conroe. This Lakefront condo offers it all. Newly updated, marvelous marble counter tops throughout including in the primary bathtub, elegant backsplash, two bedrooms with an extra space that could be utilized as your office or an extra bedroom, fresh paint from top to bottom including the private deck, beautiful tile flooring, three car tandem garage with a workbench and tons of storage for all the lake toys, stainless steel appliances and majestic Lake views! This area of Lake Conroe has every amenity you\'ll ever need at your fingertips. Topnotch Restaurants, shopping, nightlife, and of course, all the Lake activities you can handle!' ,`Acres` = '0.0275' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'REGENCY POINT, LOT 65 REPLAT' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '1200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '406' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Regency Point' ,`TaxAmount` = '3513' ,`TaxRate` = '2.1625' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584302' WHERE `Matrix_Unique_ID` = '214134691' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:28:41.490' ,`MLSNumber` = '75333935' ,`ListAgentFullName` = 'John Green' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = 'John Green' ,`SellingOfficeName` = 'Keller Williams Realty' ,`Latitude` = '30.787874' ,`Longitude` = '-96.377358' ,`PhotoCount` = '29' ,`PostalCode` = '77808' ,`RoomCount` = '7' ,`ListPrice` = '225000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Mesquite Meadow' ,`StreetNumber` = '5563' ,`StreetSuffix` = 'Lane' ,`City` = 'Bryan' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2048' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a beautiful, well maintained home siting on one acre of land. Enjoy being close to town but outside the Bryan city limits on this quiet property. The spacious 2,048 sf, three bedroom, two bath home has been recently upgraded. Upgraded features include new flooring one year ago, new carpeting in the bedrooms replaced in October, and new kitchen appliances and updates added this year. A new back porch and asphalt 2 car drive pad were added. A metal roof was added seven years ago and double pane windows were replaced six years ago. The AC unit is only six years old. The spacious master bath with soaking tub and separate shower, vanities and walk-in closet with seal the deal.\r\n\r\nThe handyman in the family will love the 20\' X 40\' workshop with 110v, 220v electric power and water. A smaller shed also has electric and water. The large fenced backyard has plenty of room for family entertaining, gardens and more. The kitchen refrigerator will convey.' ,`Acres` = '1.009' ,`Area` = '61' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'Standing Rock Ranch, Lot 26, Acres 1.009 Ser#PH518563A, HUD#' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '43952' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'NAVARRO ELEMENTARY SCHOOL (BRYAN)' ,`SchoolHigh` = 'JAMES EARL RUDDER HIGH SCHOOL' ,`SchoolMiddle` = 'ARTHUR L. DAVILA MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Standing Rock Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584303' WHERE `Matrix_Unique_ID` = '214149068' --> 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','214152003','1668584303','214152003','2022-11-15T21:32:44.407','94203996','Janet Thuy Bui','HomeSmart','','','29.712977','-95.566599','2','77072','4','339000.00','Active','LINNHAVEN','6203','Drive','Houston','2','0','4','2114','Single-Family','2114 sq. ft. BEAUTIFUL REMODELED, WELL MAINTAINED, 4 BEDROOMS open concept ready to move in home. NEW ROOF, NEW 5 TON HVAC /DUCTS SYSTEM/GRILLS, NEW PEX WATER SUPPLY LINES, NEW LAMINATE WOOD LOOK FLOORING, LUXURIOUS KITCHEN and MASTERBATH QUARTZ COURTERTOPS, NEW LG APPLIANCES, COMPLETED REMODELED SHAKER CABINETS HALL and MASTERBATH ROOM, WALKING IN CLOSET. NEW PAINT INTERIOR and EXTERIOR, UPDATED LIGHTING FIXURES. LOFT CAN BE 4th BEDROOM, WORK AT HOME OFFICE, GAME ROOM. Living room and kitchen overlook relaxing backyard dinning and entertaining NO NEIGHBORS. Located in the best Asian restaurants in the heart of Alief! Easy access to Beltway 8 and Westpark Tollway. \r\nOwner Agent. We invite you to tour the property. Thank you for showing.','','28','','','Electric Dryer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Alief','Central Gas','1','LT29 BLK6 BRAYS VILLAGE EAST SEC 1','Subdivision Lot','4500','Appraisal District','','315','0','','2','Electric Oven','0','','','Electric Range','','Composition','2 - Alief','CHANCELLOR ELEMENTARY SCHOOL','AISD DRAW','ALIEF MIDDLE SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','1.5','Contemporary/Modern,Traditional','BRAYS VILLAGE EAST','','2.44106','Public Sewer,Public Water','1978','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:16:47.063' ,`MLSNumber` = '60961484' ,`ListAgentFullName` = 'Guang Yang' ,`ListOfficeName` = 'Texas Signature Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.579557' ,`Longitude` = '-95.587129' ,`PhotoCount` = '42' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Springfield Lakes' ,`StreetNumber` = '4535' ,`StreetSuffix` = 'Street' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2804' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated in a great community and prime location ( zoned to TOP rated Clements High School with excellent middle and elementary schools ) this traditional brick home is filled with every convenience with close proximity to grocery stores( 99 Ranch Market, Jusgo Supermarket, Welfresh Market, HEB) restaurants, and shopping centers (First Colony Mall). An open concept floor plan filled with sunlight throughout the house, A large living space, Game room with master bedroom downstairs and three additional bedrooms upstairs makes one have to see this house, to appreciate the great vibe!' ,`Acres` = '0.1578' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEFIELD SEC 2, BLOCK 2, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6872' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '780' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'AUSTIN PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakefield Sec 2' ,`TaxAmount` = '5878' ,`TaxRate` = '2.1594' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584303' WHERE `Matrix_Unique_ID` = '214155056' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:16:02.527' ,`MLSNumber` = '45948745' ,`ListAgentFullName` = 'Rose King' ,`ListOfficeName` = 'David Tracy Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.498584' ,`Longitude` = '-94.983740' ,`PhotoCount` = '38' ,`PostalCode` = '77518' ,`RoomCount` = '10' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Chase Stone' ,`StreetNumber` = '4927' ,`StreetSuffix` = 'Drive' ,`City` = 'Bacliff' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2458' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This great home was made for entertaining! A real beauty! The large living room has soaring 2-story ceilings and a cozy fireplace for cold winter nights. The large gourmet kitchen is open to the living room and is right off of the formal dining room. There is no carpet in this beautiful home. The flooring is all wood or tile. The beautiful staircase leads to an upstairs game room that is open to the living room below. There is a nice bedroom downstairs that can be a guest room, office or playroom for the kids. The very large primary bedroom suite is upstairs. The over-size primary bath features a deep soaking tub, a walk-in shower, walk-in closet and separate sinks. Two additional bedrooms are up, along with a cozy nook that is perfect for a study area, and a nice game room. The back yard features a new covered deck and plenty of room for the kids and pets. The neighborhood boasts a community pool, playground, and baseball field. Conveniently located near shopping and entertainment.' ,`Acres` = '0.136' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 88 A HATCH SUR LOT 2 BLK 5 CHASE PARK SEC 4 (2004),' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5922' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'KENNETH E. LITTLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Chase Park Sec 4 2004' ,`TaxAmount` = '5994' ,`TaxRate` = '2.2342' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584303' WHERE `Matrix_Unique_ID` = '214157782' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:04:54.430' ,`MLSNumber` = '22444157' ,`ListAgentFullName` = 'Julie Tyson' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = 'Tram Tran-Nguyen' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '30.097831' ,`Longitude` = '-95.567953' ,`PhotoCount` = '35' ,`PostalCode` = '77375' ,`RoomCount` = '7' ,`ListPrice` = '370000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Dale River' ,`StreetNumber` = '22922' ,`StreetSuffix` = 'Road' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2286' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seller has chosen an offer. No more showings. MULTIPLE OFFERS. Deadline for highest and best is Tuesday, 11/15/2022 at 10:00am. You’ll fall in love the moment you walk into this gorgeous single-story home! It has a fresh coat of interior and exterior paint. It boasts high ceilings, an open concept, and a chef’s delight with its double oven. The kitchen offers granite countertops, stainless steel appliances, an island, a roomy pantry, a coffee bar, and a large breakfast bar. The primary bedroom presents you with a view of the amazing backyard. Did I mention you’ll never have backyard neighbors in this home?! The primary bathroom has two granite countertop vanities, a soaking tub, a large shower, and a massive walk-in closet. This home has a desirable layout, roomy secondary bedrooms, an office with an abundance of space, and a three car garage. Come check it out today!' ,`Acres` = '0.182' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 3 WILLOW LAKE VILLAGE AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MAHAFFEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Lake Village' ,`TaxAmount` = '8388' ,`TaxRate` = '2.9373' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584303' WHERE `Matrix_Unique_ID` = '214222191' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:17:22.943' ,`MLSNumber` = '41264068' ,`ListAgentFullName` = 'Cynthia Gueta' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804940' ,`Longitude` = '-94.894657' ,`PhotoCount` = '37' ,`PostalCode` = '77523' ,`RoomCount` = '6' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Levant' ,`StreetNumber` = '2011' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1714' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home!!! This is a move-in ready, 4 sided brick, single story 2020 Energy Efficient Beazar home. This open concept floor plan features 3 bedroom, 2 full baths, and separate tub/shower in primary suite. You will also find stainless steel appliances, fridge, hurricane shutter panels included and an Outdoor covered patio perfect for a soothing evening. Less than 5 Minutes away from local shopping, restaurants and 99.' ,`Acres` = '0.1377' ,`Area` = '53' ,`BuilderName` = 'Beazar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLK 1 LOT 16 SOUTHWINDS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '523' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwinds Sec 1' ,`TaxAmount` = '6098' ,`TaxRate` = '2.8882' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584304' WHERE `Matrix_Unique_ID` = '214234662' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:14:19.103' ,`MLSNumber` = '61137199' ,`ListAgentFullName` = 'D\'Andra Singleton' ,`ListOfficeName` = 'Sapphire Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.101332' ,`Longitude` = '-94.140681' ,`PhotoCount` = '6' ,`PostalCode` = '77706' ,`RoomCount` = '5' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Shady' ,`StreetNumber` = '2145' ,`StreetSuffix` = 'Lane' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1692' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Coming Soon!!!\r\nAll brick 4 bedroom 2 bath home on a large lot. New paint, floors, appliances, lighting, cabinets, updates galore. Come take look at this beautiful home.' ,`Acres` = '0.2893' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CALDER PL L28 B43' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'REGINAL-HOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Calder Place' ,`TaxAmount` = '4123' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584304' WHERE `Matrix_Unique_ID` = '214276039' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:03:43.263' ,`MLSNumber` = '30269257' ,`ListAgentFullName` = 'Elizabeth Rodriguez' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698667' ,`Longitude` = '-95.548118' ,`PhotoCount` = '26' ,`PostalCode` = '77036' ,`RoomCount` = '9' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Sandstone' ,`StreetNumber` = '9311' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1992' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this well kept beautiful home! Conveniently located in Chinatown, and in the middle of all kinds of shops, restaurants, Grocery stores, and more! Easy access to Sam Houston Tollway, Westpark Tollway and HWY 69 South. This home has 4 bedrooms 2 bath, family room, Formal Livingroom, Dining room, and breakfast area. Plenty of room to keep guest comfortable. It also has a large back patio to enjoy your summers out back. Owners installed new roof back in 2012, A/C was installed in 2016. This home is just waiting for you to add your touches and call it yours. Schedule your showing today!' ,`Acres` = '0.1909' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 33 SHARPSTOWN COUNTRY CLUB TERRACE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8315' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHITE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR GROVE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharpstown Country Club Terrac' ,`TaxAmount` = '5032' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584304' WHERE `Matrix_Unique_ID` = '214289668' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:21:48.290' ,`MLSNumber` = '87598753' ,`ListAgentFullName` = 'Dwight Johnson' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.470941' ,`Longitude` = '-95.475857' ,`PhotoCount` = '44' ,`PostalCode` = '77459' ,`RoomCount` = '13' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'Star Lake' ,`StreetNumber` = '246' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3712' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country Estate Living in Houston’s Premier Acreage community. Seated on just under four wooded acres. The home is perfect for a young family with small children or retirees who love watching the grands run around. The property is a must see and is priced at a fraction of what you could buy land and build for. Too many features to name but here’s a few. Plantation shutters, five-inch hand scraped wood flooring, granite tops, stainless appliances, custom built bunk beds, frameless glass shower with four heads, storm safe room with cinder block walls/ceiling. Detached flex space can be an office, nanny quarters or anything else you choose. The insulated metal barn for RV storage also comes with a BendPak 10k LB lift to store more cars in case your four-car oversized garage isn\'t enough. 800 Sq Ft of covered area off barn for outdoor entertainment. Lastly, the home has a whole house generator. Seller will consider selling including some non-realty items with a strong offer.' ,`Acres` = '3.97' ,`Area` = '38' ,`BuilderName` = 'Kurk Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA POINT SEC 1, BLOCK 2, LOT 3 (NOT IN SIENNA PLANTATION' ,`LotDesciption` = 'Other,Subdivision Lot,Wooded' ,`LotSize` = '170886' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Point' ,`TaxAmount` = '11958' ,`TaxRate` = '1.7629' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668584304' WHERE `Matrix_Unique_ID` = '214291907' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:31:08.893' ,`MLSNumber` = '19560275' ,`ListAgentFullName` = 'Karen Benson' ,`ListOfficeName` = 'C.R.Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764596' ,`Longitude` = '-95.558103' ,`PhotoCount` = '34' ,`PostalCode` = '77024' ,`RoomCount` = '4' ,`ListPrice` = '2199000.00' ,`Status` = 'Active' ,`StreetName` = 'Faust' ,`StreetNumber` = '206' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This unique home is zoned to the highly desirable Memorial Bend Subdivision with the best top tier schools in the greater Houston area, Rummel Creek Elementary, Memorial Middle and High School. This smart home features interior and exterior LED lighting for energy conservation, smart fans, stunning master suite with ceiling cedar beams, luxurious master bath with Lazuli High polished porcelain, his and hers spacious closets. Office and dining room ceiling cedar beams with large windows for natural light radiating throughout. Rococo brushed engineered Harwood floors. Spectacular kitchen with Quartz countertops with mitered edge design, stainless steel appliances, 6 gas burner grill cooktops, trash compactor and wine room. All stucco exterior, Outdoor kitchen with close to half an ACRE backyard for outdoor entertainment. Close to major retail, restaurants, City Centre, Memorial Mall, and seconds away from Terry Hershey Park!' ,`Acres` = '0.4804' ,`Area` = '23' ,`BuilderName` = 'ADC Construction Inc' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 1 MEMORIAL BEND SEC 4' ,`LotDesciption` = 'Other' ,`LotSize` = '20927' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '411' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'RUMMEL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Memorial Bend' ,`TaxAmount` = '15340' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584304' WHERE `Matrix_Unique_ID` = '214316023' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:51:19.980' ,`MLSNumber` = '31466506' ,`ListAgentFullName` = 'Shelly Faust' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.340384' ,`Longitude` = '-95.083340' ,`PhotoCount` = '20' ,`PostalCode` = '77327' ,`RoomCount` = '4' ,`ListPrice` = '130000.00' ,`Status` = 'Active' ,`StreetName` = 'Taft' ,`StreetNumber` = '122' ,`StreetSuffix` = 'Avenue' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Why rent when you can own your own home? This cute little cottage has two bedrooms and one bath. It sits on a nice lot with plenty of space in the backyard to add a firepit or a lounge/play area. It has been updated with a newer roof (2021), new flooring, cabinets, stove, and paint. It also has updated windows. It is located on a quiet street in the city of Cleveland and is within walking distance to a grocery store, gas station, restaurants and more.' ,`Acres` = '0.1664' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'COX-GARVEY-CLEV, BLOCK 23, LOT 10, ACRES .1664' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7248' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cox-Garvey-Clev' ,`TaxAmount` = '1185' ,`TaxRate` = '2.5563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584305' WHERE `Matrix_Unique_ID` = '214317188' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:12:03.683' ,`MLSNumber` = '77688782' ,`ListAgentFullName` = 'Tanya Nero' ,`ListOfficeName` = 'The Rogers Group Realty' ,`SellingAgentFullName` = 'Tanya Nero' ,`SellingOfficeName` = 'The Rogers Group Realty' ,`Latitude` = '29.664393' ,`Longitude` = '-95.352239' ,`PhotoCount` = '10' ,`PostalCode` = '77033' ,`RoomCount` = '2' ,`ListPrice` = '119999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Alvin' ,`StreetNumber` = '4809' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Are you looking for an investment property in an upcoming area?! 4809 Alvin St is a 2 bedroom 1 bathroom single family home with the garage converted into a second living room. Washer and dryer connections located inside the second living room area. Currently occupied with a month-to-month tenant paying $850 in monthly rent. This home is being sold as is. Contact listing agent with any questions.' ,`Acres` = '0.1488' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 6 CHOCOLATE BAYOU ESTATES SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Left Side,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chocolate Bayou Estates Sec 01' ,`TaxAmount` = '1831' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584305' WHERE `Matrix_Unique_ID` = '214324477' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:25:54.297' ,`MLSNumber` = '3049507' ,`ListAgentFullName` = 'Vianey Del Castillo' ,`ListOfficeName` = 'Select Pro Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822137' ,`Longitude` = '-95.800222' ,`PhotoCount` = '29' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Alberelli' ,`StreetNumber` = '3242' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and see what this beautiful home has to offer. Spacious one story floor plan. Open concept kitchen, living and dining space perfect for entertaining and family time. Beautiful kitchen area with 42 inch cabinets with granite countertops. Large Master bedroom with in suit and walk-in closet. Secondary bedrooms are privately situated away from the owners retreat \r\nThis community has an amenity center with a resort-style pool as well as two sparkling lakes open for water sports. A new HEB coming soon. Camillo Lakes’ excellent location off the Grand Parkway and Interstate 10 puts you near favored Katy attractions such as Typhoon Lagoon as well as shopping and dining at Katy Mills Mall. Minutes to TX-99 and I-10. Call and make an appointment today!!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 2 CAMILLO LAKES SEC 3' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '4950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584305' WHERE `Matrix_Unique_ID` = '214337830' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:39:30.760' ,`MLSNumber` = '11836116' ,`ListAgentFullName` = 'Lina Monteverde' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.752014' ,`Longitude` = '-95.867628' ,`PhotoCount` = '36' ,`PostalCode` = '77494' ,`RoomCount` = '8' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Port Mist' ,`StreetNumber` = '2718' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Gorgeous freshly painted, 3018 Sq Ft, 4 bedroom, 3 bathroom Perry home on a cul-de-sac with private pool is ready for its new owner(s)! Upon entry, you are greeted with a spacious flex area. Beautiful glass paned french doors leads to the private study features dark, rich wood flooring and has plenty of space for larger office furniture! Elegant formal dining room boasts double tray ceiling and large arched windows. Stunning great room has tons of windows allowing in ample natural light and views into the idyllic backyard oasis. Gourmet chefs kitchen is open to the family room featuring dark cabinets, granite countertops, tile backsplash, stainless steel appliances, and oversized island allowing additional seating and storage. Primary bedroom with luxurious ensuite bathroom offers soaking tub, dual sinks, and separate shower! 3 Spacious secondary bedrooms! 2 of them share a double sink bathroom and the 3rd one is located in a separate hallway and has it\'s own bathroom.' ,`Acres` = '0.1659' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FIRETHORNE WEST SEC 1, BLOCK 2, LOT 20' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7227' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`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` = 'Traditional' ,`Subdivision` = 'Firethorne West Sec 1' ,`TaxAmount` = '8774' ,`TaxRate` = '2.5848' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584305' WHERE `Matrix_Unique_ID` = '214373562' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:59:45.920' ,`MLSNumber` = '29293429' ,`ListAgentFullName` = 'Sonia Ponce' ,`ListOfficeName` = 'Houston Center Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.856634' ,`Longitude` = '-95.315761' ,`PhotoCount` = '10' ,`PostalCode` = '77016' ,`RoomCount` = '2' ,`ListPrice` = '152000.00' ,`Status` = 'Active' ,`StreetName` = 'Westbrook' ,`StreetNumber` = '5406' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1287' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTMENT PROPERTY on a large corner lot, rooms size approximate. Buyer and buyers agent to verify. Sqft is based on HCAD, please also verify. Seller does not have survey, buyer to purchase new if needed. SOLD AS IS. Please drive by, bookmark listing for open house notification.' ,`Acres` = '0.396' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 128 & 129 BLK 8 BRISTOL PLACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '17250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bristol Place' ,`TaxAmount` = '2051' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584306' WHERE `Matrix_Unique_ID` = '214394467' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:55:37.247' ,`MLSNumber` = '27595530' ,`ListAgentFullName` = 'Sonia Ponce' ,`ListOfficeName` = 'Houston Center Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.817856' ,`Longitude` = '-95.331162' ,`PhotoCount` = '10' ,`PostalCode` = '77026' ,`RoomCount` = '2' ,`ListPrice` = '112000.00' ,`Status` = 'Active' ,`StreetName` = 'King' ,`StreetNumber` = '4014' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investment property for sale, rooms size approximate. Buyer and buyers agent to verify. Sqft is based on HCAD, please also verify. Seller does not have survey, buyer to purchase new if needed. No repairs will be done, SOLD AS IS. Please drive by, bookmark listing for open house notification.' ,`Acres` = '0.2009' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 264 BLK 10 WILSHIRE PLACE' ,`LotDesciption` = 'Other' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KASHMERE GARDENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilshire Place' ,`TaxAmount` = '1235' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1938' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584306' WHERE `Matrix_Unique_ID` = '214394764' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:17:45.313' ,`MLSNumber` = '21715367' ,`ListAgentFullName` = 'Allison Tims' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.286297' ,`Longitude` = '-95.478874' ,`PhotoCount` = '23' ,`PostalCode` = '77304' ,`RoomCount` = '10' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'Windsor' ,`StreetNumber` = '19' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2436' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW PICTURES JUST ADDED 11/9!! KITCHEN COMPLETED UPDATED with Beautiful QUARTZ Countertops! New Backsplash. ALL NEW FLOORING Downstairs!! HUGE PRIMARY SUITE with Huge Walk-in Closet and Double Doors to In-suite Bathroom with Soaking Tub!! . All nice size BR\'s with Walk-in Closets! BRAND NEW AC!! NEW Dishwasher! NEW Fence with Double Gates! NEW push button Toilets! Kitchen has New Disposal, New Sink, Updated Lighting and New Paint! Features gas appliances and opens to breakfast and family room. Lots of windows to invite natural sunlight! Both formals. Covered Patio overlooks Large Private Backyard with a very nice sized Shed with AC! Large lot in the Beautiful neighborhood of Rivershire. Centrally located just minutes to I-45, Lake Conroe is Only 15 Minutes Away! Woodlands Mall 10 minutes away! Brand new stores all around!! You Are Going to LOVE Living Here!!' ,`Acres` = '0.2348' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERSHIRE 02 BK 7 LT 35&W31\'OF LT 36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10229' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RICE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Rivershire 02' ,`TaxAmount` = '6586' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584306' WHERE `Matrix_Unique_ID` = '214398855' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:23:44.367' ,`MLSNumber` = '87941200' ,`ListAgentFullName` = 'Dane Gates' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = 'Clint Nabors' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.146842' ,`Longitude` = '-95.673393' ,`PhotoCount` = '50' ,`PostalCode` = '77362' ,`RoomCount` = '8' ,`ListPrice` = '650000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Majestic Shores' ,`StreetNumber` = '738' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Truly STUNNING Drees Custom Home located in the beautiful, amenity rich, Woodtrace community! 3 Bed/3 Bath home with Oversized Garage that backs to a serene nature preserve. This home shows like a model! Gourmet Kitchen w/ Huge Island, Breakfast Bar, Designer White Cabinets, Display Cabinets with Lighting, Dbl Ovens, 6 Burner Gas Range, Incredible Storage, Beautiful Quartz Countertops and Butler\'s Pantry. Open concept Family Room with Exposed Beams and Panaramic Doors Overlooking The Wooded Nature Preserve. Beautiful Hardwood Floors throughout. Primary Suite with amazing bath that features a large walk in shower, soaking tub, and walk in closet. Bedroom 2 with on suite bath and Bedroom 3 with Off Suite Bath. Dedicated Study/Media Room with French Doors. Awesome covered patio with fans and integrated audio. Extremely Energy Efficient Home! Woodtrace features amenities that include a recreation center with pool, clubhouse, greenbelt, trails and 23 acre spring fed lake with fishing dock.' ,`Acres` = '0.214' ,`Area` = '15' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S959406 - WOODTRACE 06, BLOCK 1, LOT 23' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '9321' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '13991' ,`TaxRate` = '3.2015' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584306' WHERE `Matrix_Unique_ID` = '214418198' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:41:38.270' ,`MLSNumber` = '4291399' ,`ListAgentFullName` = 'Gloria Lucas' ,`ListOfficeName` = 'Guardian Angel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.300652' ,`Longitude` = '-96.131493' ,`PhotoCount` = '8' ,`PostalCode` = '77488-5638' ,`RoomCount` = '5' ,`ListPrice` = '165000.00' ,`Status` = 'Active' ,`StreetName` = 'Moutray' ,`StreetNumber` = '621' ,`StreetSuffix` = 'Avenue' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property needs some TLC. Sits on 2 Lots. This Lovely 3 BdRm / 2 Bath is on a corner lot with a nice and cozy front porch. The living and dining room is separate. Den/family room overlook the large, fenced back yard. Sold AS IS.\r\n\r\nThe HAR Property General Description of the property does not reflect the property accurate number of rooms or bathrooms.\r\nRooms, lot & building size measurements and year built to be verified by buyers. SOLD AS IS' ,`Acres` = '' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 4 & 5; Blk 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11300' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'River Road' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668584307' WHERE `Matrix_Unique_ID` = '214437683' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:52:01.210' ,`MLSNumber` = '8174876' ,`ListAgentFullName` = 'Sonia Ponce' ,`ListOfficeName` = 'Houston Center Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.023773' ,`Longitude` = '-95.313683' ,`PhotoCount` = '19' ,`PostalCode` = '77338' ,`RoomCount` = '3' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Fox Swift' ,`StreetNumber` = '20911' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home, this beautiful three bedroom home is move in ready. Home features fireplace in living room, laminate flooring in living room and dining area, breakfast nook in kitchen, large primary bedroom with walk in closet. Community amenities include pool, tennis court, soccer field and clubhouse. Located near 59 and 45 off 1960, Minutes from Cypress Trails Horseback Riding, Bush Airport, Jones Park and more. Room size approximate, buyer and buyers agent to verify. ' ,`Acres` = '0.1085' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 BLK 4 FOXWOOD SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Foxwood Sec 10' ,`TaxAmount` = '4366' ,`TaxRate` = '2.7734' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584307' WHERE `Matrix_Unique_ID` = '214439116' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:40:59.413' ,`MLSNumber` = '75829099' ,`ListAgentFullName` = 'Melanie Shadwick' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.973601' ,`Longitude` = '-95.657198' ,`PhotoCount` = '43' ,`PostalCode` = '77429' ,`RoomCount` = '14' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Hall' ,`StreetNumber` = '15938' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Coles Crossing, Cy-Fair ISD, 3,492 sq ft, 1.5 story, never flooded home is ready for you at any stage of your life! Lounge in the fence-enclosed, safe patio play area, float in the gunite pool or sunbathe on the baja shelf while listening to the pool\'s built-in rock and water feature. The upstairs bonus room provides open space for crafting, playing, a media room, home school classroom, or an exercise room- the possibilities are up to your imagination! Additional Home details- 3 zoned ACs, 2 new in 2020, 3 attic access points for smart home upgrades and attic storage space, whole house surge protector, Ecobee Thermostat, 2 Wi-Fi Garage Openers, 240V adapter for Electric Vehicle Charging 2018(Tesla), Polaris pool equipment 2022, new paint 2022, bathroom faucets fixtures 2022. Master Plan Community Amenities/Events- Turkey Trot, Garage Sales, Blood Drives,Holiday Festivals & Parties,private event spaces,pools,swim team,splash area,playgrounds,volleyball,tennis,stocked pond.' ,`Acres` = '0.2106' ,`Area` = '10' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 3 COLES CROSSING SEC 15' ,`LotDesciption` = 'Corner' ,`LotSize` = '9174' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SAMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Coles Crossing' ,`TaxAmount` = '9532' ,`TaxRate` = '2.531' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584307' WHERE `Matrix_Unique_ID` = '214473197' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:32:17.937' ,`MLSNumber` = '88382575' ,`ListAgentFullName` = 'Folorunso Akindoju' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.802063' ,`Longitude` = '-95.737499' ,`PhotoCount` = '10' ,`PostalCode` = '77449' ,`RoomCount` = '14' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Juniper' ,`StreetNumber` = '20423' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1776' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this lovely 3 bedroom home in Raintree Village. This home is literally minutes away from I-10 and Grand Parkway. This property has a large back yard great for an add on or pool. It has no back neighbors and a nice covered porch. Inside the house has both formal living and dinning, laminated wood floors, ceramic tiles in all 3 bathrooms, granite counter tops, Kitchenette, stylish barn doors, a downstairs bonus area and most of the home has been newly updated. The subdivision of Raintree Village is established and has many amenities including a public pool and is zoned for Highly acclaimed Katy ISD Schools. It is also close to the British international school. Don\'t miss out! Schedule a showing today!' ,`Acres` = '0.1748' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 5 RAINTREE VLG SEC 1 R/P & EXTN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FRANZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MORTON RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Raintree Village Sec 01 Reserve A' ,`TaxAmount` = '5187' ,`TaxRate` = '2.5633' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584307' WHERE `Matrix_Unique_ID` = '214479185' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:52:01.207' ,`MLSNumber` = '34048036' ,`ListAgentFullName` = 'Aidee Sanchez' ,`ListOfficeName` = 'JPAR Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.180994' ,`Longitude` = '-95.500285' ,`PhotoCount` = '34' ,`PostalCode` = '77381' ,`RoomCount` = '7' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Placid Hill' ,`StreetNumber` = '18' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2165' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful & conveniently situated in the Heart of The Woodlands! This home has been completely remodeled with exceptional construction and meticulous attention to detail. Enter through the stunning foyer that flows into the family room boasting natural light from every direction. Kitchen includes stainless steel appliances & polish nickel finishes that compliment & give this all white kitchen a crisp & flawless look! Retreat into your master suite with spa-like master bathroom featuring a large frameless shower, double shower heads, soaking tub, double vanity, & GRAND MASTER CLOSET with soaring vaulted ceilings! Make all of your fantasies come true with this stunner! Upstairs features 3 additional bedrooms, which include an office. Large outdoor deck overlooks the back yard & features plenty of space for outdoor lounging & entertaining! New exterior doors, A/C, air ducts, & water heater. LOCATION, LOCATION, LOCATION - easy & quick access to all the amenities The Woodlands has to offer!' ,`Acres` = '0.2078' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL COCHRANS CR03, BLOCK 1, LOT 22' ,`LotDesciption` = 'Wooded' ,`LotSize` = '9050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'DAVID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Cochrans Cr 03' ,`TaxAmount` = '6451' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584307' WHERE `Matrix_Unique_ID` = '214498228' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:09:53.427' ,`MLSNumber` = '35219301' ,`ListAgentFullName` = 'Jennifer Johnston' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.267580' ,`Longitude` = '-95.544646' ,`PhotoCount` = '50' ,`PostalCode` = '77316' ,`RoomCount` = '13' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Hunter Hollow' ,`StreetNumber` = '143' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This GORGEOUS Village Builders home is located in the highly sought after Master Planned Golf Course Community of WOODFOREST. Featuring 5 BEDROOMS (2 on the 1st floor), 4 FULL bathrooms, media room, game room, formal dining, office with stunning wood beam coffered ceiling, gourmet kitchen, butlers pantry and so much more! The exterior of this home offers an EXTRA WIDE DRIVEWAY, epoxy floor 3 CAR garage with bump out for EXTRA STORAGE, separate fenced side yard with AUTO PET DOOR, beautifully landscaped RETREAT-STYLE backyard with POOL, STACKED STONE SPA, PERGOLA, covered patio, paver decking and sidewalks! This home is centrally located within the community, walking distance to Stampede Sportsplex, Christine Allen Nature Park, Fox Trail Park and numerous hiking, biking, and walking trails. Come call this beautiful community home! Book your appointment today!' ,`Acres` = '0.3407' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S965245 - WOODFOREST 45, BLOCK 3, LOT 5' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '14840' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 45' ,`TaxAmount` = '13877' ,`TaxRate` = '2.6888' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584308' WHERE `Matrix_Unique_ID` = '214504803' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:55:34.907' ,`MLSNumber` = '93152541' ,`ListAgentFullName` = 'Eleny-Ly Ruiz' ,`ListOfficeName` = 'Kodu Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.678130' ,`Longitude` = '-95.296438' ,`PhotoCount` = '28' ,`PostalCode` = '77087' ,`RoomCount` = '7' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Pebble' ,`StreetNumber` = '6019' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1992' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this recently remodeled home. Plumbing, electrical, roof, double paned windows and HVAC were replaced 2014/2015. As you enter you are welcomed by open living/dining concept with formal living and dining/breakfast area. Depending on how you would like to use the space - there is a perfect area for home office/study as well. 4 bedrooms with 2 full bathrooms. All great size with good amount of closet space. Home is priced to sell asap. Please call to schedule showings. NO HOA fee!' ,`Acres` = '0.1641' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 10 TROPICANA VILLAGE' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CORNELIUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tropicana Village' ,`TaxAmount` = '4407' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584308' WHERE `Matrix_Unique_ID` = '214504838' --> 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','214507894','1668584308','214507894','2022-11-15T21:42:16.817','49041351','Jennifer Hansen','Keller Williams Premier RealtyKaty','','','29.743562','-95.798737','50','77494','9','438000.00','Active','Ginger Ranch','25139','Drive','Katy','2','1','4','2789','Single-Family','DARLING 4 BEDROOM 2.5 BATH home FULL OF CUSTOMIZED FEATURES is ready for new owners! Upon entry you will be welcomed w/ a dark wood shiplap lined ceilings & a double door glass entry to an office w/lighted custom bookcases. Large kitchen w/wood beams, granite counters & stainless appliances. Family room w/white wood trimmed fireplace & marble surround & wainscotting that continues throughout the home. Primary suite w/built in electric fireplace, barn doors & added cabinetry in the bath & closet. 3 BR up, one with 4 \"pinterest style\" individually lighted twin bed alcoves, another room has a triple bunk bed & built in desk area & the 3rd bedroom feature shiplap walls & a walk in closet. Love STAR WARS? The game room (currently being used as a 4th bedroom) has a built in IMPERIAL AT AT on the wall along w/wall of built ins. Finished attic space for extra storage options.Tons of custom landscaping added along with a backyard patio pergola w/string lighting & a shed that stays. KATY ISD.','0.1157','36','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Katy - Southwest','Central Gas','1','KATY CREEK RANCH SEC 4, BLOCK 2, LOT 13','Subdivision Lot','5040','Appraisal District','','410','0','','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','30 - Katy','RYLANDER ELEMENTARY SCHOOL','CINCO RANCH HIGH SCHOOL','CINCO RANCH JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Katy Creek Ranch Sec 4','6285','2.3545','Public Sewer,Public Water,Water District','2009','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:28:10.810' ,`MLSNumber` = '78617925' ,`ListAgentFullName` = 'Vanessa Hyman' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825772' ,`Longitude` = '-95.794374' ,`PhotoCount` = '48' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Varano' ,`StreetNumber` = '3603' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3660' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to another gem of Marcello Lakes, a beautiful modern home with amazing water views.\r\n\r\nThe home has it all ! \r\nStarting with the grand 2 story foyer, high ceilings, built- in character walls. Built in media system. Super bright natural light !\r\n \r\nThe home office/ study is spacious. \r\nChef\'s kitchen has a breakfast area and an open family concept area.\r\nFireplace & covered outdoor area \r\nOut door is pre-wired for an outdoor chefs kitchen. \r\nMaster bedroom has high ceilings , bay windows , California style closet, views of the lake. \r\nLarge walk in closets throughout entire home \r\nMedia room.\r\nGame room.\r\nUp Stairs covered patio. Views\r\nSerene Awaits You !' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Princeton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 Marcello Lakes Sec 2' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '7148' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marcello Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584308' WHERE `Matrix_Unique_ID` = '214514940' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:45:25.027' ,`MLSNumber` = '29225161' ,`ListAgentFullName` = 'Alexander Barrios' ,`ListOfficeName` = 'Krueger Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.970715' ,`Longitude` = '-95.177404' ,`PhotoCount` = '34' ,`PostalCode` = '77346' ,`RoomCount` = '10' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Cook Forest' ,`StreetNumber` = '17627' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3153' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pride of ownership shines throughout in this updated, traditional home. Designer lighting upgrades throughout, custom built in shelving and cabinets in the dining room, secondary bedroom, and laundry room. Wood blinds throughout the home. Smart appliances, thermostat, sprinklers, light switches and dimmers, can all be controlled from the palm of your hands. Kitchen has high end stainless appliances, Granite countertops, spacious island, & upgraded wood white shaker style cabinets. Home has tons of storage with extensive flooring in the garage attic, pots and pans shelved storage. Imagine entertaining with a covered back patio on a huge lot! Other features include; Family room and bonus room are pre-wired for speakers, Dishwasher replaced in 2022, Genarac generator installed in August 2022, Two additional backdraft dampers added to HVAC system in 2022, French drains installed in backyard during construction of home. House is clean & well maintained. Don\'t miss this great opportunity.' ,`Acres` = '0.3571' ,`Area` = '1' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 2 GROVES SEC 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '15554' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1128' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Groves Sec 5' ,`TaxAmount` = '12716' ,`TaxRate` = '3.443' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584308' WHERE `Matrix_Unique_ID` = '214522627' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:38:34.430' ,`MLSNumber` = '5774321' ,`ListAgentFullName` = 'Eddie Parker' ,`ListOfficeName` = 'Exit Realty 360' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699744' ,`Longitude` = '-95.362157' ,`PhotoCount` = '43' ,`PostalCode` = '77021' ,`RoomCount` = '3' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Zephyr' ,`StreetNumber` = '3727' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1159' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 2 Bedroom 2 Bath entirely remodeled from front yard to back with stylish all black hardware throughout is a must see. GE double oven, 30 inch 5 burner gas cooktop with 30 inch stainless hood vent. GE Dishwasher, 30 inch Barn sink 10” deep W/Disposal. Mosaic glass backsplash. Quartz countertops with White Shaker style cabinets. Quartz floating vanities in each bathroom. high-efficiency16 series AC Unit. A 40 Gallon Electric Water Heater. 8 Camera Lorex DVR system with 19 inch Monitor. Porcelain Wood Appearance Tiles throughout the house along with Freshly Carpeted Bedrooms. Modern Ceiling fans in every room to include the Covered rear patio deck off of a Huge totally sodded privacy 6 ½ foot fenced in backyard.' ,`Acres` = '0.1608' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 1 LA SALETTE PLACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7006' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '35' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'THOMPSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'La Salette Place Sec 01' ,`TaxAmount` = '2291' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584309' WHERE `Matrix_Unique_ID` = '214536404' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:51:44.453' ,`MLSNumber` = '23122274' ,`ListAgentFullName` = 'Roxanna Plazas' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.861357' ,`Longitude` = '-95.199167' ,`PhotoCount` = '36' ,`PostalCode` = '77044' ,`RoomCount` = '9' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Vanessa Glen' ,`StreetNumber` = '9722' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1602' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This beautiful 4 bedroom 2 bathroom property built in 2018 is located in Hidden Meadow Subdivision. Open concept kitchen with kitchen island and 42 inch cabinets. Dining and living area have an open layout great for entertaining. Energy efficient features include insulated/low E windows, radiant attic barrier and programmable thermostat. No carpet at all, vinyl and tile throughout the house. The bedrooms are very spacious and cozy. The house is located nearby shopping and dining. Easy access to Beltway, Hwy 59 and I-10. Come make this yours!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21, Block 1, Section 12' ,`LotDesciption` = 'Other' ,`LotSize` = '5486' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'CARROLL ELEMENTARY SCHOOL (SHELDON)' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hidden Meadow' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668584309' WHERE `Matrix_Unique_ID` = '214543582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:51:10.743' ,`MLSNumber` = '64716412' ,`ListAgentFullName` = 'Karen Davis' ,`ListOfficeName` = 'KLD Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723568' ,`Longitude` = '-95.862052' ,`PhotoCount` = '42' ,`PostalCode` = '77441' ,`RoomCount` = '10' ,`ListPrice` = '879000.00' ,`Status` = 'Active' ,`StreetName` = 'Enchanted Shores' ,`StreetNumber` = '28315' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4327' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION! This stunning waterfront home in the award-winning subdivision of Cross Creek Ranch has breathtaking views and incredible sunsets. Inside features \"wood like\' tile floors, Plantation Shutters, upgraded Berber carpet, high ceilings and open floorplan. Huge Island Kitchen with granite, GE stainless steel appliance package, lots of cabinets, recessed and pendent lights. Family Room with wall of windows, sliding glass door, gas log Fireplace, beamed ceiling. Large Primary Suite with tray ceiling. Primary Bath with double sinks, groin ceiling, chandelier, standalone MAAX soaker tub and oversized walk-in closet. The second floor has a huge Game Room, Media Room, 2 secondary Bedrooms and 2 Full Baths. Close to private pocket park and walking distance to a Day Care and KISD Elementary, Junior High and High School. Convenient to grocery stores, restaurants, and retail stores. The subdivision also has a waterpark, pools, restaurant, dog park and workout facility.' ,`Acres` = '0.2321' ,`Area` = '36' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK COVE AT CROSS CREEK RANCH SEC 10, BLOCK 1, LOT 21' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '10109' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '18126' ,`TaxRate` = '3.3425' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584309' WHERE `Matrix_Unique_ID` = '214554641' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:20:25.067' ,`MLSNumber` = '67405644' ,`ListAgentFullName` = 'Candice Ayala' ,`ListOfficeName` = 'Covington Signature Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.689372' ,`Longitude` = '-95.500566' ,`PhotoCount` = '7' ,`PostalCode` = '77074' ,`RoomCount` = '8' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Albacore' ,`StreetNumber` = '8303' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful corner lot in the sought-after Robindell Neighborhood, close to Meyerland Plaza, the Medical Center, Downtown, and the Galleria!! Situated on a HUGE corner lot with beautiful, mature trees, this open floor plan features site-built cabinetry, contemporary tile flooring, low-energy windows, granite counters, stainless appliances, upgraded lighting, and a backyard oasis.' ,`Acres` = '0.1791' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 2 ROBINDELL SEC 1 R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '40' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MCNAMARA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR GROVE MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Robindell Sec 01 R/P' ,`TaxAmount` = '6167' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584309' WHERE `Matrix_Unique_ID` = '214573982' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:05:07.467' ,`MLSNumber` = '68358143' ,`ListAgentFullName` = 'Lacy Lewis' ,`ListOfficeName` = 'Mr. Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.621917' ,`Longitude` = '-95.359817' ,`PhotoCount` = '15' ,`PostalCode` = '77047' ,`RoomCount` = '5' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Donegal' ,`StreetNumber` = '12933' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant New custom home beauty on a large corner lot! Beautiful front stone elevation with covered front entryway. High ceilings & built in\'s throughout! Engineered wood flooring. This 3 bedroom 2.5 bath home is a one of kind with open layout and high end kitchen with a waterfall island. This is the largest lot of 3 homes to be built, its a must see home!' ,`Acres` = '0.1639' ,`Area` = '3' ,`BuilderName` = 'Private Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 16 SHAMROCK MANOR' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '7140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shamrock Manor' ,`TaxAmount` = '494' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668584310' WHERE `Matrix_Unique_ID` = '214609906' --> 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','214620275','1668584310','214620275','2022-11-15T22:22:07.323','78156462','LaQuana Davis','Brooks & Davis Real Estate','','','29.624035','-95.416374','19','77045','8','310000.00','Active','Inland Hill','14022','Street','Houston','3','0','5','2368','Single-Family','Welcome to Bayou Oaks at West Orem. A private gated community with excess to all major freeways. LOCATION, LOCATION!! \r\nGreat floor plan!! Hone features 5 bedrooms and 3 full baths! Formal living area off the entrance, very spacious kitchenOVERSIZED with lots of counter space, and hugh bar, spacious livingroom open to kitchen and breakfast area. The oversized primary bedroom with large walk-in closet located upstairs with guest room downstair and 2 additional bedrooms upstairs!! Nice size back yard with covered patio great for family entertainment and plenty of room for kids to play. This is a beautiful starter home is awaiting its next owner. This home has only has one owner newly constructed.','0.1256','18','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Five Corners','Central Electric','1','LT 10 BLK 1 BAYOU OAKS AT WEST OREM SEC 2 R/P','Cul-De-Sac','5470','Appraisal District','','700','0','','2','Freestanding Oven','0','','','Freestanding Range,Gas Range','','Composition','27 - Houston','PETERSEN ELEMENTARY SCHOOL','MADISON HIGH SCHOOL (HOUSTON)','LAWSON MIDDLE SCHOOL','Accompany,Appointment Required,Controlled Access','Appraisal District','2','Traditional','Bayou Oaks/West Orem Sec 02','6163','2.8907','Water District','2011','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:08:28.070' ,`MLSNumber` = '95865619' ,`ListAgentFullName` = 'Monica Darr' ,`ListOfficeName` = 'American Realty' ,`SellingAgentFullName` = 'Kendrick Mayberry' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '29.349476' ,`Longitude` = '-95.509583' ,`PhotoCount` = '50' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '875000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pearce' ,`StreetNumber` = '2903' ,`StreetSuffix` = 'Meadow' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3673' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The home you\'re looking for is this one with over 3,600 square feet of living space including 4/5 bedrooms, 3 full baths and 2 half baths on 2 acres! It was recently renovated less than a year ago with a fabulous chef\'s kitchen plus an amenities list too numerous to include here but it is attached - talk about SMART TECHNOLOGY, that\'s included, too. Some upgrades to the exterior of the property include an automatic gate that leads into your private backyard oasis that includes a screened enclosed patio with an upgraded pool and stamped concrete just waiting on someone like yourself who loves their outdoor areas. You\'ll also find 6 ft fencing around all parts not only giving them added security but leaving no question about what belongs where - inside or out: unless we\'re talking chickens - Haha. Property has NEVER FLOODED! Give me a call or call your favorite REALTOR to schedule your private showing.' ,`Acres` = '2' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'SUNCREEK RANCH SEC 2 (A0125 A ROBINSON) BLK 1 LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Suncreek Ranch Sec 1-2-3-4' ,`TaxAmount` = '11408' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic,Public Water,Well' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584310' WHERE `Matrix_Unique_ID` = '214626245' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:58:36.670' ,`MLSNumber` = '63233082' ,`ListAgentFullName` = 'Danny Vu' ,`ListOfficeName` = 'Danny Vu Realty' ,`SellingAgentFullName` = 'Jorge Maldonado' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '29.907672' ,`Longitude` = '-95.313258' ,`PhotoCount` = '13' ,`PostalCode` = '77039' ,`RoomCount` = '8' ,`ListPrice` = '199900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sandydale' ,`StreetNumber` = '5223' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful large brick home in a great neighborhood, with 4 bedrooms (2 primary) and 3 full baths, large formal living room could be 5 bedroom or media room, huge kitchen with granite countertops, SS appliances, 6 yrs old roof and furnace, fully fenced backyard with no back neighbor. Minutes from downtown, Bush Airport, Dearbrook Mall, Hwy 59, and BW8. Come see it today before it\'s gone tomorrow.' ,`Acres` = '0.1818' ,`Area` = '34' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 210 BLK 2 FAIRGREEN SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'OLESON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MACARTHUR HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'MEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairgreen Sec 02' ,`TaxAmount` = '4452' ,`TaxRate` = '2.9881' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584310' WHERE `Matrix_Unique_ID` = '214647841' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:03:03.487' ,`MLSNumber` = '82164766' ,`ListAgentFullName` = 'Isamar Castillo-Salande' ,`ListOfficeName` = 'Executive Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.990868' ,`Longitude` = '-95.165447' ,`PhotoCount` = '20' ,`PostalCode` = '77346' ,`RoomCount` = '6' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Thicket Trail' ,`StreetNumber` = '7407' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SO MUCH SPACE EVERYWHERE! Walk into this beautiful home and to the right you have a living/media room area with a dining area. This area can be used for an office space, second living room, or game room. The Kitchen has a beautiful open view of both living areas with a large peninsula for plenty of seating and great spot for kiddos to do their homework! The primary living area with the large brick fireplace is a perfect centerpiece with tons of character for your company to enjoy! The Primary bedroom is GENEROUSLY sized, fits plenty of furniture to make it your own! The Primary bath has double sinks with custom closet shelves for organizing. The Back Patio has beautiful brick and has plenty of room for outdoor activities and gatherings! The back patio has double access, from the primary family room and from the primary bedroom! Minutes to BW8! within minutes from schools assigned to property, minutes from Atascocita Shopping Center (Grocery and more), several gyms located nearby!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 19 ATASCOCITA SOUTH SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6868' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'TIMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Atascocita South' ,`TaxAmount` = '3812' ,`TaxRate` = '2.3974' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584310' WHERE `Matrix_Unique_ID` = '214649653' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:21:13.053' ,`MLSNumber` = '87477900' ,`ListAgentFullName` = 'A. Selena Barr' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.850146' ,`Longitude` = '-95.814412' ,`PhotoCount` = '32' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Whitehaven Gate' ,`StreetNumber` = '25422' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1659' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome HOME to this ONE story, very well maintained home, owned by original owner. Beautiful marble styled tile throughout home, except for (2) smaller bedrooms. Both the MASTR Bdrm & MSTR Bathroom offers tile as well. Kitchen offers all stainless appliances (INCLUDING REFRIGERATOR, dishwasher, disposal, microwave and GAS Stove and Range overlooking the great room/living and dining areas! The laundry room is located inside the home near secondary bedrooms and bathroom and master bedroom is located in the back of the home facing the back yard.' ,`Acres` = '0.1148' ,`Area` = '25' ,`BuilderName` = 'KB Lone Star INC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 3 KATY MANOR SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Katy Manor Sec 8' ,`TaxAmount` = '7135' ,`TaxRate` = '3.4768' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584310' WHERE `Matrix_Unique_ID` = '214678178' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:18:06.887' ,`MLSNumber` = '93572369' ,`ListAgentFullName` = 'Diem Chu' ,`ListOfficeName` = 'ABSOLUTE Realty Group Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.707116' ,`Longitude` = '-95.578232' ,`PhotoCount` = '11' ,`PostalCode` = '77072' ,`RoomCount` = '6' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Yupon Ridge' ,`StreetNumber` = '4454' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly update with new paint, granite counter top, laminate floor in bedrooms, mini blinds with open floor plan, built-in bookcase/cabinet with shelves in living room and in garage, tile in all wet area. House is in convenience location near Hong Kong supermarket, west park tollway, Beltway 8 and walking distance to Chancelor Elementary School. One of the owners is a real estate agent. Please contact your agent to schedule showing.' ,`Acres` = '0.0868' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 5 BRAYS VILLAGE SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '285' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'CHANCELLOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALIEF MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brays Village Sec 02 R/P' ,`TaxAmount` = '3728' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584311' WHERE `Matrix_Unique_ID` = '214680650' --> 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','214681840','1668584311','214681840','2022-11-15T22:58:09.140','66369165','Kasie Chambers','eXp Realty, LLC','','','29.531144','-95.397861','16','77578','11','599900.00','Active','Maple Oak','2722','Lane','Manvel','4','0','5','3419','Single-Family','One of Highland Homes\' most loved floorplans nestled in the highly sought-after neighborhood of Pomona. A community who cares deeply about their homeowners and shows it! If space is what you are looking for, look no further! Offering 5 bedrooms, 4 full bathrooms with 2 bedrooms on first floor. This floor plan provides a spacious office and formal dining on the first floor and not 1 but TWO game room spaces on the 2nd floor! This home is an absolute must see!','0.1793','5','Highland Homes','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','1','Gas Connections','1','Alvin North','Central Gas','1','POMONA SEC 2 (A0417 ACH&B & A0540 ACH&B) BLK 2 LOT 4','Subdivision Lot','7810','Appraisal District','','1190','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','POMONA ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','RODEO PALMS JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Contemporary/Modern,Traditional','Pomona Sec 2 A0417 Ach&B & A0','16283','3.6594','Water District','2016','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T22:51:49.120' ,`MLSNumber` = '84037063' ,`ListAgentFullName` = 'Raul Quintanilla' ,`ListOfficeName` = 'Jose Garza Agency' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.341906' ,`Longitude` = '-95.285905' ,`PhotoCount` = '1' ,`PostalCode` = '77328' ,`RoomCount` = '4' ,`ListPrice` = '298000.00' ,`Status` = 'Active' ,`StreetName` = 'Walker' ,`StreetNumber` = '2547' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1328' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2547 N.Walker. Completely unrestricted property with just a little under 3 acres. Opportunities are endless here\r\n2 rooms and one bathroom with an additional double wide that only needs connection to the home so that it can add more rooms and living space to the current home. Cleared and cleaned only and fence for privacy. Book your showing now with your favorite Realtor.' ,`Acres` = '2.27' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0088 - BARTON H, TRACT 11, ACRES 2.27' ,`LotDesciption` = 'Cleared' ,`LotSize` = '98881' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Hail Barton Surv Abs # 88' ,`TaxAmount` = '2877' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584311' WHERE `Matrix_Unique_ID` = '214683592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:35:56.173' ,`MLSNumber` = '39154518' ,`ListAgentFullName` = 'Karen Mills' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812139' ,`Longitude` = '-95.714512' ,`PhotoCount` = '17' ,`PostalCode` = '77084' ,`RoomCount` = '7' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunrise Chase Way' ,`StreetNumber` = '19630' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2126' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1- story home in Creek Bend Estates- Ready for move in. Refrigerator, washer, and dryer are included.\r\nThis home has 3 bedrooms, 1 game room/den, and 2 full baths. Beautiful open island kitchen with gas range, the Large family room opens to the kitchen and formal dining. Spacious master bedroom with garden bath and separate shower. Make this your new home.\r\nHouse has been totally painted and carpet replaced' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 3 CREEK BEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'STEPHENS ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Creek Bend Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668584311' WHERE `Matrix_Unique_ID` = '214696090' --> 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','214722312','1668584311','214722312','2022-11-15T22:09:30.357','7862166','Jerry Jaggers','Boulevard Realty','','','29.823983','-95.431195','26','77018','6','599000.00','Active','Kinley','1233','Lane','Houston','3','0','5','1818','Single-Family','Large and extremely sought after lot in Oak Forest Section 1. Located in the middle of a small curved block off Ella between 34th and 43rd. Surrounded by gorgeous construction. Attached is a video showing both sides of this premier block. After a 1965 renovation this home became one of the Biggest and Grandest homes on the block with a new open concept design, large living room with beamed ceilings, 5 bedrooms 3 full baths, 3 fireplaces, streamlined second story, huge back yard, chicken coop and oversized garage. Now,...it is one of the oldest, smallest and most humble around. I was brought home there after being born at Heights Hospital. I have had dinner there on Tuesdays ever since through 2021. I even took refuge there in the 2020 Texas Freeze as this home produced warmth with or without electricity. I hope that whoever gets this land will build an extraordinary home.','0.2077','9','','','','','Estate','','','2','Oak Forest East Area','Space Heater','0','LT 22 BLK 4 OAK FOREST SEC 1','Subdivision Lot','9046','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','OAK FOREST ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Temporarily No Showings','Appraisal District','1.5','Traditional','Oak Forest Sec 01','9309','2.3307','Public Sewer,Public Water','1949','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:02:06.990' ,`MLSNumber` = '73674738' ,`ListAgentFullName` = 'Elizabeth Manriquez' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.178661' ,`Longitude` = '-95.167975' ,`PhotoCount` = '35' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '469000.00' ,`Status` = 'Active' ,`StreetName` = 'Whispering Pine' ,`StreetNumber` = '2218' ,`StreetSuffix` = '' ,`City` = 'Roman Forest' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**UNDER CONSTRUCTION! PRICING WILL ESCALATE AS HOME NEARS COMPLETION, BUY EARLY SAVE MONEY. Estimated Completion December 31st 2022**\r\nBeautiful new custom built home located in popular Roman Forest TX. Sitting on almost half an acre this 3 bedroom, 3 bath, 3 car garage equipped with electric vehicle charging stations, garage also opens up to huge backyard so you can back up your trailer etc... Office/study room can be used as an additional bedroom. Home features include modern pivot door, tall ceilings, electric fireplace, LED lighting throughout home, Samsung appliances, quartz countertops, custom high cabinets, tile floor throughout the home and carpet in bedrooms. Amazing covered back patio with a large backyard. Roman Forest is off of I-69 and minutes from the Grand Pkwy and Valley Ranch Town Center. Quiet, safe and friendly neighborhood which has a community pool, splash pad, pavilion and park for residents. Deed restrictions, No HOA, No Fees!! Schedule your appointment today!' ,`Acres` = '0.4591' ,`Area` = '40' ,`BuilderName` = 'EENN HOMES, LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ROMAN FOREST 01, BLOCK 11, LOT 5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Craftsman' ,`Subdivision` = 'Roman Forest 01' ,`TaxAmount` = '959' ,`TaxRate` = '2.9064' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668584311' WHERE `Matrix_Unique_ID` = '214724075' --> 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','214724974','1668584312','214724974','2022-11-15T21:36:24.597','90711596','Gavannie Beharie','MIH REALTY, LLC','','','29.911779','-95.723195','28','77433','4','477200.00','Active','Broad Harbor','20327','Lane','Cypress','3','0','4','3188','Single-Family','Opulent and functional single-family home in Miramesa community. Before entering the home you’ll be charmed by the curb appeal and community, this home backs-up to the lake (get ready to enjoy dawns and sunsets). Within its walls you’ll find: formal dining, office, media room, three amply sized bedrooms, huge master w/ ensuite bathroom and walk-in closet and centrally open concept kitchen with all the amenities you can imagine. It’s move-in ready; freshly painted through-out and all features are like new. All Bedrooms are outfitted with ceiling fans and solid hardwood flooring (No carpet anywhere). The kitchen features built-in wine racks, Stainless steel appliances, extensive cabinetry, and both island and peninsula (must see). Master bathroom is another highlight of this home; its garden tub, separate shower, private commode and double vanity meets about every need. Short commute to Towne Lake Boardwalk, Lone Star College Cy-fair, etc. plus easy access to 290 and 99. Your dream home!','0.2482','25','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Owner/Agent,Sellers Disclosure','1','','1','Cypress South','Central Gas','1','LT 10 BLK 2 MIRABELLA SEC 7','Corner,Water View','10811','Appraisal District','','1300','0','','2','Convection Oven,Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','POSTMA ELEMENTARY SCHOOL','CYPRESS SPRINGS HIGH SCHOOL','ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Accompany,Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern','Mirabella Sec 7','10396','3.041','Water District','2015','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214745615','1668584312','214745615','2022-11-15T22:19:18.130','53111321','Kashmir Cortave','The Monarch Team, LLC','','','29.880050','-95.142433','23','77044','10','350000.00','Active','Wandering Creek','15414','Trail','Houston','2','1','4','2836','Single-Family','Sheldon Ridge is perfectly located 3 miles from Beltway 8, minutes from schools and blocks way from being able to fish. This gorgeous two story house is waiting to welcome you home. The primary is conviently located on the first floor along with a home office. The media room AND gameroom are upstairs, along with three additional bedrooms.','0.1373','2','','','','','Sellers Disclosure','1','','1','North Channel','Central Gas','1','LT 20 BLK 4 SHELDON RIDGE SEC 10','Subdivision Lot','5979','Appraisal District','','365','0','','2','','0','','','','','Composition','46 - Sheldon','SHELDON ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','MICHAEL R. NULL MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Other Style','Sheldon Rdg Sec 10','9952','3.6393','Public Sewer,Public Water','2020','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','214747764','1668584312','214747764','2022-11-15T22:52:00.693','27012353','Dorian Brown','Geek Realty Group','','','29.560114','-95.765417','15','77469','4','260000.00','Active','Crestwood','2104','Drive','Richmond','2','0','3','1603','Single-Family','Huge Lot over 10,000 Square Feet with Mature Trees.This house was designed with the first time homebuyer in mind that wants something a little different then what\'s on the market.A little modern, a little retro, with a little old Richmond charm.Office with solid wood french doors off the entry. New vinyl wood flooring in entire house. Fresh paint inside and out.new dishwasher, Double ovens in kitchen with under cabinet lighting. Your own fig tree in back yard.Double sinks in primary bath along with oversized shower.New fans and Fixtures. Beautiful Beams in the living area, with Built ins. 2 inch thick Granite in the kitchen with back splash, Double pane windows through the house, Recent water heater, New Garage Doors, Recent Piping in attic, over sized Shed of 16ftx12ft , as well as 19x11 Sunroom.smoke/ carbon monoxide detecter.Updated electrical panel in 2019.Oversized Garage of 20x29.Cold Ac, No flooding ever. Make your appointment today.','0.2314','30','','','Electric Dryer Connections,Gas Dryer Connections','','Mud,Owner/Agent','1','Wood Burning Fireplace','1','Fort Bend South/Richmond','Central Electric','0','CLAIRMONT ACRES, LOT 22','Subdivision Lot','10080','Appraisal District','','0','0','','2','Double Oven','0','','','Electric Cooktop','','Wood Shingle','33 - Lamar Consolidated','SMITH ELEMENTARY SCHOOL (LAMAR)','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Ranch,Traditional','Clairmont Acres','3564','2.3748','Public Sewer,Public Water','1970','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','214766041','1668584312','214766041','2022-11-15T22:05:52.040','10266224','Raphael Ogbongbemiga','Discovered Homes Inv. Inc.','','','29.845912','-95.705451','50','77449','3','309000.00','Active','Broadwind','19210','Lane','Katy','2','1','3','2448','Single-Family','This single-family home is located at 19210 Broadwind Ln, Katy, TX. 19210 Broadwind Ln is in Katy, TX and in ZIP code 77449. This property has 3 bedrooms, 2.5 bathrooms and approximately 2,448 sqft of floor space. This property has a lot size of 4965 sqft and was built in 2001.','0.1136','25','','','','','Sellers Disclosure','1','','1','Bear Creek South','Central Gas','1','LT 17 BLK 1 WINDSTONE COLONY SEC 1','Other','4950','Appraisal District','','600','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','SHERIDAN ELEMENTARY SCHOOL','CYPRESS LAKES HIGH SCHOOL','THORNTON MIDDLE SCHOOL (CY-FAIR)','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','2','Other Style','Windstone Colony Sec 01','5621','2.781','Public Sewer','2001','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T21:57:03.793' ,`MLSNumber` = '39229850' ,`ListAgentFullName` = 'Verlina Whatley' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.682828' ,`Longitude` = '-95.624336' ,`PhotoCount` = '17' ,`PostalCode` = '77083' ,`RoomCount` = '9' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Evansdale' ,`StreetNumber` = '13718' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2229' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Only 3 Years Young, This is a beautiful 4 Bedroom, 2 1/2 Bath home. Kitchen has beautiful White Cabinets, Stainless Steel Appliances, including Fridge; Granite Counters and separate breakfast room. Gorgegous Vinyl plank flooring throughout the main floor of the home. Primary Bedroom has Separate Shower and Garden Tub. Good Size Closet Space throughout the home. Quaint Back Covered Patio perfect for entertaining.' ,`Acres` = '0.1006' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 2 ELDRIDGE PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4384' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '960' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HICKS ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Eldridge Park Sec 1' ,`TaxAmount` = '7876' ,`TaxRate` = '2.753' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668584312' WHERE `Matrix_Unique_ID` = '214769498' --> 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','214772466','1668584312','214772466','2022-11-15T21:22:45.387','57199319','Kirk Williams','UTR TEXAS, REALTORS','','','29.511477','-95.162675','50','77546','11','850000.00','Active','King George','3318','Lane','Friendswood','5','1','5','5252','Single-Family','Must see to believe with this breathtaking remodeled home in Friendswood Oaks. This home boasts 5 bedrooms with an additional bedroom that is being used as a game-room with kitchenette. Two bedrooms on the first floor. Grand foyer with custom detailing in every corner you turn. Tall ceilings in living room with open kitchen any gourmet chef would envy with exquisite granite, Thermador appliances and custom cabinetry. Oversized primary suite has enormous master closet made for a movie star! Primary en suite has beautiful soaking tub with large walk-in shower that feels like a spa. Upstairs you will find large bedrooms with two full baths. No need to go to the movie theater when you have professional sound in media room! Outside you will find a beautiful pool/hot tub area. The enclosed pool house has custom kitchen, fireplace, full bath, heat, a/c and sitting area. Home has no back neighbors to enjoy the view! Come take a look at all this unique home has to offer!','0.2686','7','','','Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace,Mock Fireplace','3','Friendswood','Central Gas','1','LT 4 BLK 3 FRIENDSWOOD OAKS SEC 2','Greenbelt,Subdivision Lot','11700','Appraisal District','','650','0','','3','Gas Oven','1','Gunite,Heated,In Ground','','Gas Range','','Composition','9 - Clear Creek','LANDOLT ELEMENTARY SCHOOL','CLEAR SPRINGS HIGH SCHOOL','BROOKSIDE INTERMEDIATE SCHOOL','Appointment Required,Controlled Access,No Supra Keybox','Seller','2','Traditional','Friendswood Oaks','14276','2.2534','Public Sewer,Public Water','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','214783174','1668584312','214783174','2022-11-15T21:41:24.637','80917883','Wes Stoyanov','Luxury Homes Realty','','','29.851496','-95.457171','6','77091','5','1300000.00','Active','Mansfield','3322','Street','Houston','2','0','3','2820','Single-Family','2 ACRES GREAT FOR NEW CONSTRUCTION DEVELOPMENT - LOT IS SURROUNDED BY NEW CONSTRUCTION. CALL AGENT WITH ANY QUESTIONS. NICELY GATED PROPERTY WITH A LIVEABLE HOUSE ON SITE.','0.7544','9','','','','','No Disclosures','','','','Northwest Houston','Central Gas','0','LT 58 LT 59 BLK 23 HIGHLAND HEIGHTS ANNEX SEC 4','Other','87120','Appraisal District','','','0','','1','','0','','','','','Composition','1 - Aldine','HARRIS ACADEMY','EISENHOWER HIGH SCHOOL','HOFFMAN MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','Highland Heights Anx Sec 04','5928','2.5119','Public Sewer,Public Water','1998','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','214790553','1668584312','214790553','2022-11-15T22:43:34.160','48716670','Alex Tarre-Townsend','NextHome Realty Center','','','30.101900','94.189310','19','77713','8','225990.00','Active','Blue Bonnet','7996','Street','Beaumont','2','0','3','1551','Single-Family','WONDERFUL LOCATION! Priced to sell. This beautiful home offers tons of upgrades, from wood & tile flooring to plantation shutters and heat lamps in bathrooms, This home has it all. Great kitchen with loads of cabinets and shelves for cookbooks, stainless steel appliances including the refrigerator! Spacious family room, fireplace with gas logs is the perfect size for Santa! The back patio/porch has been transformed into an extra flex room/office not included in the total sqft of the house. The primary offers coffered ceilings, hardwood flooring and large walk in closet. The ensuite bathroom has a double sink vanity, linen closet, separate shower and relaxing jetted tub. Huge lush backyard with built in raised garden beds and additional storage shed! The attic is also floored for additional holliday storage. Just in time to make this home yours for 2023. WELCOME HOME!','0.1442','51','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','','Central Gas','0','ORCHID ESTATES LOT 2','Subdivision Lot','6283','Appraisal District','','','0','','2','Gas Oven','0','','','Electric Range','','Composition','143 - Beaumont','REGINAL-HOWELL ELEMENTARY SCHOOL','WEST BROOK HIGH SCHOOL','MARSHALL MIDDLE SCHOOL (BEAUMONT)','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern,Traditional','Orchid Estates','5176','2.6134','Public Sewer,Public Water','2005','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214790680','1668584312','214790680','2022-11-15T21:08:17.900','67373601','Elisa Noriega','NB Elite Realty','','','30.344624','-95.532091','7','77304','6','488000.00','Active','Catoti Cay','208','Court','Conroe','3','1','4','2662','Single-Family','Welcome Home! This amazing Two-Story Plan Offers 4 Bedrooms, 3.5 Bathrooms, Game Room, Covered Outdoor Living Space + 2 Car Garage, this Beauty does not disappoint! Wide Open Concept Great Space Features Oversized Granite Chef\'s Kitchen, Large Casual Dining that Opens to the Family Room. Master Retreat has Attached Bath and a Wrapped Master Closet offering direct access to Utility. Upstairs houses 3 Beds, 2 Full Baths and Game Room. Stainless Steel Appliance Pkg w/ 42\" Cabinetry, Wood Tile Flooring, Gutters, Upgraded Carpet, 2\" Blinds, Automatic Garage Door Opener, Sprinkler System, Fully Sodded Yard + Landscape\nThis property is also for lease: $3,300 a month. ','0.116','19','','','','','Sellers Disclosure','1','Gaslog Fireplace','1','Lake Conroe Area','Central Gas,Zoned','1','S582100 - HILLS OF WESTLAKE 01, BLOCK 7, LOT 45','Cul-De-Sac','5054','Appraisal District','','650','0','','2','','0','','','','','Composition','11 - Conroe','GORDON-REED ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Hills Of Westlake 01','621','2.9803','Public Sewer,Public Water','2020','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','214794609','1668584312','214794609','2022-11-15T21:22:53.403','23826845','Jessica Moreno','Keller Williams Realty - Memorial','','','29.871094','-95.426598','44','77088','3','257500.00','Active','Victory','984','Drive','Houston','2','0','3','1802','Single-Family','Welcome to 984 N Victory Dr located on the corner of this up an coming neighborhood! This 3 bedroom, 2 bath home features an open floor plan, spacious front and backyard enclosed with a beautiful black metal gate, TWO beautiful magnolia trees in the front yard, a nice front porch to enjoy morning coffee as well as a back porch to relax and have parties in your large backyard! Home is like new with wood color flooring and fresh paint, recessed lighting in living area, new light fixtures and new fans throughout home, new plumbing, and new electrical panel. New kitchen with all new cabinets, white backsplash, granite countertops, new stainless steel gas range, new stainless steel dishwasher, and new stainless steel microwave and breakfast kitchen island with space for you to add stools . Bathrooms have new tile throughout, new vanities w/granite, new fixtures, and new mirrors! Bedrooms all have new carpet & new ceiling fans. Home also has new HVAC! Lots happening in this area. Buy now!','0.167','11','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Northwest Houston','Central Gas','0','LT 141 BLK 6 LINCOLN CITY SEC 7','Corner','7276','Appraisal District','','','0','','0','','0','','','Gas Range','','Composition','27 - Houston','OSBORNE ELEMENTARY SCHOOL','WASHINGTON HIGH SCHOOL','WILLIAMS MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Lincoln City Sec 07','1671','2.3307','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully