Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:13:37.073' ,`MLSNumber` = '23250232' ,`ListAgentFullName` = 'Rebecca Thomas' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.863773' ,`Longitude` = '-94.852669' ,`PhotoCount` = '33' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'River Run' ,`StreetNumber` = '12110' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2222' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLER!!!! Seller will consider all reasonable offers. This is a corner lot, recently replaced HVA, new carpet, wood laminate floors & a shed! Whether you are looking to plant your roots in the growing town of Mont Belvieu (in one of the most desired neighborhoods!) or you are looking for an excellent investment proerty - this is the home for you! Zoned to Barbers Hill ISD North, this home has never flooded, has city services available and has plenty of room! Enjoy the great location - near many new shopping and dining attractions with more on the way! Call today to see this well-kept home.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 167 FISHERS LANDING II' ,`LotDesciption` = 'Corner' ,`LotSize` = '11326' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Call Occupant,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fishers Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779142' WHERE `Matrix_Unique_ID` = '209305319' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:23:13.447' ,`MLSNumber` = '85017476' ,`ListAgentFullName` = 'Kristin McAlister' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822037' ,`Longitude` = '-95.440102' ,`PhotoCount` = '32' ,`PostalCode` = '77018' ,`RoomCount` = '3' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Ebony' ,`StreetNumber` = '1615' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Located in the desirable Oak Forest area- shopping, dining, entertainment and outdoor activities are in walking distance! This layout is perfect for entertaining and will not disappoint. The backyard space is truly an oasis featuring a fire pit area and deck with covered pergola overlooking the lush, manicured landscaping. The backyard truly is a showpiece! This immaculately cared for home boasts a ton of updates! Some of which include: PEX re-pipe, recent roof replacement with radiant roof barrier and gutter upgrade, siding replacement and painting, electrical upgrade/update, sprinkler installation, garage Elfa organization system, front window replacement, water heater replacement and more. Additionally, inside, the original floors have been refinished, cabinets have been painted, SS appliances upgraded (washer and dryer included), and Elfa system in master bedroom. This home truly is a must see- schedule your tour today!' ,`Acres` = '0.1653' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 34 BLK 47 OAK FOREST SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest Sec 06' ,`TaxAmount` = '8531' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779142' WHERE `Matrix_Unique_ID` = '209342800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:27:16.573' ,`MLSNumber` = '97816091' ,`ListAgentFullName` = 'Kelley Banks' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Sonya Wyche' ,`SellingOfficeName` = 'USA I Asset Group Corp' ,`Latitude` = '29.526149' ,`Longitude` = '-95.564804' ,`PhotoCount` = '27' ,`PostalCode` = '77479' ,`RoomCount` = '7' ,`ListPrice` = '499000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Hickory Branch' ,`StreetNumber` = '4603' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3291' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant home on Corner lot in Millwood at Riverstone, Zoned to Ann Sullivan Elementary. Home has high ceilings, lots of natural light and plantation shutters throughout. Extended entry leads to over sized family room, which opens up to Kitchen with NEWLY installed Cooktop. Kitchen also has a large granite island bar and double ovens that provides additional seating. Home has two bedroom suites on the first floor, perfect for Multi-Generational Living. Spacious Primary bedroom has a wall of windows, and a large bathroom with separate tub and shower and two walk in closets. Features private study, media room and game room. Over-sized 2.5 car garage. Large backyard with French drains, sprinkler system, covered patio. Refrigerator, Washer, Dryer, Stationery Bike, Rower and Outside Grill INCLUDED!' ,`Acres` = '0.2116' ,`Area` = '29' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MILLWOOD AT RIVERSTONE SEC 3, BLOCK 3, LOT 6' ,`LotDesciption` = 'Corner' ,`LotSize` = '9216' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Millwood At Riverstone Sec 3' ,`TaxAmount` = '10496' ,`TaxRate` = '2.6729' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779142' WHERE `Matrix_Unique_ID` = '209574599' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:23:14.013' ,`MLSNumber` = '52168533' ,`ListAgentFullName` = 'Michael Gore' ,`ListOfficeName` = 'RE/MAX Distinction' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.364979' ,`Longitude` = '-95.491000' ,`PhotoCount` = '39' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '949000.00' ,`Status` = 'Active' ,`StreetName` = 'Mission Oaks' ,`StreetNumber` = '1706' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4061' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ONE - OF - A - KIND CUSTOM HOME boasts 3/4 bedrooms including 3 down. 1706 Mission Oaks Court is a bespoke home by respected Royal Texan Homes, inspired by Andrea Palladio. Features include a prodigious list of upscale design exhibiting two stories of spectacular opulence. Over 4000 sq feet of living space, elegantly inaugurated with six sets of French doors, floor to ceiling windows, soaring interiors and anthology lighting. \r\n J. Kraft cabinetry, wired for sound!!\r\n 3 bedrooms (down) with 1 office/ bedroom (up) and 3 1/2 baths. The lovely primary bedroom leads through 2 Walk-Ins and into the gorgeous bathroom, double walk-thru shower and oversized soaking jacuzzi. The wine room with brick inlay is simply made for the connoisseur. Water views of the illuminated fountain, media room, game room with full bar and balcony, courtyard and the columned patio. The kitchen is adorned with high-end STAINLESS THERMADOR appliances perfect for gourmet meals. Occupied Home.' ,`Acres` = '0.1867' ,`Area` = '19' ,`BuilderName` = 'Royal Texas Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S922790 - TEASWOOD AVENUE, BLOCK 1, LOT 24' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8131' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other,Tile' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Other Style' ,`Subdivision` = 'Teaswood Ave' ,`TaxAmount` = '9655' ,`TaxRate` = '2.1823' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664779143' WHERE `Matrix_Unique_ID` = '209677803' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:07:45.827' ,`MLSNumber` = '4203954' ,`ListAgentFullName` = 'Aaron Cruz' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.693204' ,`Longitude` = '-95.476671' ,`PhotoCount` = '33' ,`PostalCode` = '77401' ,`RoomCount` = '15' ,`ListPrice` = '2099000.00' ,`Status` = 'Active' ,`StreetName` = 'Valerie' ,`StreetNumber` = '5303' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '6236' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom wood front door surround by beautiful stained glass, grand foyer leading to a private office with endless shelves. Huge formal living and dining rooms with wet bar. Chef\'s kitchen with new SS Wolf gas stove & double oven, SS double door commercial grade subzero refrigerator, 2 Asko dishwashers, walk-in pantry with a 120 bottle wine fridge. Flawless new red oak hardwood floors throughout. primary suite on the first floor features an elegant gas fireplace, gorgeous spa-like bathroom, quartz double sink vanity, frameless glass walk-in shower, soaking tub, huge walk-in closet. Second bedroom down with custom desk and en-suite. 2 half baths down. Two staircases lead you to the 4 bedrooms upstairs with crown molding, plantation shutters, built-in desk and en-suites (one Jack-n-Jill bath). Large game room with natural sky light and large windows overlooking the back yard. 4 car garage with two electric car charging ports. Per seller extensive renovations were done in 2021.' ,`Acres` = '0.47' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 12 BRAEBURN CNTRY CLUB ESTS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Braeburn Cntry Club Estates Sec 5' ,`TaxAmount` = '34491' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779143' WHERE `Matrix_Unique_ID` = '209834797' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:47:57.227' ,`MLSNumber` = '39666835' ,`ListAgentFullName` = 'Roger Walker' ,`ListOfficeName` = 'Realty Texas, LLC' ,`SellingAgentFullName` = 'James Dambeck' ,`SellingOfficeName` = 'RE/MAX Compass' ,`Latitude` = '30.124589' ,`Longitude` = '-95.611731' ,`PhotoCount` = '48' ,`PostalCode` = '77375' ,`RoomCount` = '7' ,`ListPrice` = '389999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Roanoak Woods' ,`StreetNumber` = '31031' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2247' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NO BACK NEIGHBORS! Beautiful 2247 sq.ft.1 story home on private home-site. Open Concept living at its finest! 4 Bed, 2 Ba, Dining + 3 Car Garage home! True Split plan w/ private Primary Suite w/ a dream closet is situated off the family room while the 3 other bedrooms are in the front. Amazing designer details at every corner! Beautiful hardwood and ceramic tile flooring! The kitchen has 42\" cabinets and granite countertops with a large oversized island and comes with stainless steel appliances by Frigidare! tankless water heater, as well as a sprinkler system! Also, has a storage building in the backyard.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 Blk 5 Raleigh Creek Sec 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Raleigh Crk Sec 2' ,`TaxAmount` = '6732' ,`TaxRate` = '2.92' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779143' WHERE `Matrix_Unique_ID` = '209849102' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:48:16.227' ,`MLSNumber` = '67973627' ,`ListAgentFullName` = 'Roseann Hildenbrandt' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.329042' ,`Longitude` = '-94.759685' ,`PhotoCount` = '31' ,`PostalCode` = '77327' ,`RoomCount` = '7' ,`ListPrice` = '269500.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2550' ,`StreetNumber` = '512' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1617' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RARE FIND, 1.2 acres in the heart of Cleveland. This Cedar home showcases a 60ft front porch, a circular driveway, a 20x52 4 car carport set among the mature trees and lush landscaping. Multiple out buildings including a detached 1 car garage, which has an attached covered area perfect for your riding lawn mower, storage shed, and also a greenhouse. The inside of this home showcases a spacious living area with a wood burning stove, leading into an eat in kitchen with plenty of cabinetry and counter space. Off of the kitchen is a mud room with laundry area, appliance panty or extra storage, and a built in workbench. The vast primary suite has an en-suite bath with a generous closet. Don\'t forget the oversized secondary bedroom with a spacious guest bathroom down the hallway. This home provides country living but is minutes away from amenities. Must see, call for showings!!!' ,`Acres` = '1.204' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Stove,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'OLD SNAKE RIVER LAKE ESTATES, LOT 115-119, 121, 123, SEC 4' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '52270' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '107 - Hardin' ,`SchoolElementary` = 'HARDIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Old Snake River Lake Estates' ,`TaxAmount` = '1963' ,`TaxRate` = '1.7956' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664779143' WHERE `Matrix_Unique_ID` = '210364905' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:13:17.270' ,`MLSNumber` = '55582315' ,`ListAgentFullName` = 'Suzanne Compian' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.221035' ,`Longitude` = '-95.237945' ,`PhotoCount` = '20' ,`PostalCode` = '77357' ,`RoomCount` = '5' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Olive Leaf' ,`StreetNumber` = '20846' ,`StreetSuffix` = 'Street' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'No more showings. Offer accepted . BACK ON THE MARKET !!! WOW!!! $14.17 is what the owners paid in August for electricity!!!!! You must see this back porch addition. A great place to have a bar b que or quiet time with the family. This one story, open concept home offers many upgrades. Homeowner has doubled the hang up space in the master closet and additional shelving elsewhere. For all your lawn equipment there is a 10 X 10 wooden storage shed. Refrigerator included. Elementary school is in the neighborhood. Community amenities include pool, splash pad, recreation center and walking trails. New HEB coming soon to the area. Home and neighborhood have never flooded. Shedule your showing TODAY!!! Solar Panels are installed and seller has them paid off which means very minimum monthly electricity bills to buyer. Seller can provide proof of electric bills. SELLERS ARE MOTIVATED!!' ,`Acres` = '0.1453' ,`Area` = '40' ,`BuilderName` = 'D R Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S573300 - HARRINGTON TRAILS 01, BLOCK 1, LOT 15' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6331' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails 01' ,`TaxAmount` = '3645' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779143' WHERE `Matrix_Unique_ID` = '210430928' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:23:28.340' ,`MLSNumber` = '43686608' ,`ListAgentFullName` = 'Sharon Higgins' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.371091' ,`Longitude` = '-95.324758' ,`PhotoCount` = '37' ,`PostalCode` = '77303' ,`RoomCount` = '9' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Williams' ,`StreetNumber` = '8524' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This great one story brick home sits on 10 acres, (NO Restrictions, HOA or MUD) w/3 bedrooms, 2 baths & a 2 car garage. The sellers had home built & added special touches! Wood in the home is Ash, including custom cabinetry throughout & fireplace mantle. In the den, you will notice the high ceilings, a cedar beam & a large wood burning fireplace. A few notable upgrades: windows have custom blinds & solar screens for energy efficiency, roof replaced @ 5 years ago, tile is only 4 years old. The land is cleared w/the exception of a few fruit, oak, pecan and magnolia trees. Crape myrtles line the driveway! There is a hay field, two large dog pens and a stocked pond! This property is close enough to all the amenities of Conroe, but far enough out for a little more rural feel. It is approximately 4 miles to Conroe Regional Airport, 6 miles to Conroe, 18 miles to Lake Conroe and 9 miles to the Fairgrounds. Only about a half hour to The Woodlands! Please wear mask when touring the property.' ,`Acres` = '10' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0651 SIMMONS J C, TRACT 6 & 9, ACRES 10.0214' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '435600' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Abstract Area 18' ,`TaxAmount` = '1393' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664779144' WHERE `Matrix_Unique_ID` = '210628961' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:22:45.527' ,`MLSNumber` = '48174807' ,`ListAgentFullName` = 'Joseph Perez' ,`ListOfficeName` = 'J Perez Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.609709' ,`Longitude` = '-95.195413' ,`PhotoCount` = '23' ,`PostalCode` = '77034' ,`RoomCount` = '8' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Plum Dale' ,`StreetNumber` = '10735' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1761' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE REDUCED! LOWEST IN NEIGHBORHOOD! Located near Ellington Field with access to Hwy 3, Beltway 8 and Interstate 45. This well maintained 3 bedroom 2.5 bath comes with an intercom, security cameras, deep freezer, washer, dryer and generator. Some tools in garage will remain. Never flooded. I CAN’T PROMISE YOU THE WORLD BUT CAN PROMISE THIS HOME. COME SEE TODAY!' ,`Acres` = '0.0865' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 2 SOUTHDOWN TRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3766' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'TEAGUE ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'BONDY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southdown Trace' ,`TaxAmount` = '5906' ,`TaxRate` = '3.2463' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779144' WHERE `Matrix_Unique_ID` = '210700820' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:42:29.197' ,`MLSNumber` = '79473006' ,`ListAgentFullName` = 'Jarrett Glass' ,`ListOfficeName` = 'Jarrett Glass' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.946269' ,`Longitude` = '-95.576836' ,`PhotoCount` = '15' ,`PostalCode` = '77070' ,`RoomCount` = '4' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Windriver' ,`StreetNumber` = '10415' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful 4 bed 2 bath home in northwest Houston. Very nice wood and tile floors throughout. Updated kitchen, bathrooms and fixtures. Large yard and driveway with 2 car attached garage. Close to Danish Elementary School, Bleyl Middle School, and Cypress Creek High School. Public tennis courts, park & swiming pool directly accross the street.' ,`Acres` = '0.1848' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 11 WOODEDGE VILLAGE SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'DANISH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodedge Village Sec 01' ,`TaxAmount` = '5458' ,`TaxRate` = '2.8087' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664779144' WHERE `Matrix_Unique_ID` = '210861861' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:50:43.740' ,`MLSNumber` = '94490547' ,`ListAgentFullName` = 'Jennifer McCormick' ,`ListOfficeName` = 'Lifestyles Realty, Inc.' ,`SellingAgentFullName` = 'Crystal McDonald' ,`SellingOfficeName` = 'Connect Realty' ,`Latitude` = '29.754159' ,`Longitude` = '-94.976428' ,`PhotoCount` = '27' ,`PostalCode` = '77521' ,`RoomCount` = '11' ,`ListPrice` = '227450.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Inwood' ,`StreetNumber` = '710' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifually updated home in the heart of Baytown that backs to Walker Park and Goose Creek!! Lot is neary 1 acre! Huge covered patio lets you enjoy your own land and view. Oversized covered carport in front and attached storage shed in back. Remodeled kitchen and baths with granite counters, tile floors. Bonus/gameroom. Roof & insulation 2022. This is simply a gem. Some photos have been staged to show potential.' ,`Acres` = '0.9079' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 & RES C BLK 3 CREEKWOOD SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '39550' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'ALAMO ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'HORACE MANN J H' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Creekwood Sec 02' ,`TaxAmount` = '5289' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779144' WHERE `Matrix_Unique_ID` = '210975205' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:49:43.980' ,`MLSNumber` = '92489900' ,`ListAgentFullName` = 'Brandy Archie' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.183649' ,`Longitude` = '-95.428593' ,`PhotoCount` = '15' ,`PostalCode` = '77515' ,`RoomCount` = '5' ,`ListPrice` = '315900.00' ,`Status` = 'Active' ,`StreetName` = 'Cotharn' ,`StreetNumber` = '600' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1798' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A rare find. 3-2-2 beautiful corner lot on an acre. Home has open floor plan. Kitchen has granite countertops, custom cabinets, and SS appliances . New flooring and paint throughout . Both bathrooms are completely updated . House has many updates including updated electric and plumbing , new breaker box, hot water heater, A/C and furnace are new along with roof.' ,`Acres` = '0.96' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CANNAN ACRES (ANGLETON), LOT 23, ACRES 0.960' ,`LotDesciption` = 'Corner' ,`LotSize` = '41818' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cannan Acres Angleton' ,`TaxAmount` = '5940' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779144' WHERE `Matrix_Unique_ID` = '211061148' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:11:28.573' ,`MLSNumber` = '6389290' ,`ListAgentFullName` = 'Charles Adams' ,`ListOfficeName` = 'Landmark Income Prop., Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.612011' ,`Longitude` = '-95.604373' ,`PhotoCount` = '42' ,`PostalCode` = '77478' ,`RoomCount` = '8' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'COUNTRY CLUB' ,`StreetNumber` = '1921' ,`StreetSuffix` = '' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2625' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely remodeled and Ready for Move In! 2022: Brand New Pex Plumbing, Toilets, Bath and Kitchen Fixtures, Hot Water Heater, New Wood Plank Tile Floors (Carpet in the secondary bedrooms and Walk in Closets), New Can LED Lighting, Fans, Electrical Fixtures and Breaker Box. Under Cabinet Lighting in Kitchen, Completely remodeled Primary Bath and Secondary Bath and half bath. Brand new counter tops throughout. Completely scrubbed of Wallpaper and popcorn ceilings with fresh Sheetrock and fresh new paint of the entire home. Updated stainless steel appliances in kitchen with brand new wifi enabled Double Oven. Stainless steel Samsung refrigerator stays with home; if needed. Utility Room has a space for a second refrigerator as well.' ,`Acres` = '0.2187' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 24, BLOCK 3, LOT 40' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '9526' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DULLES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Sugar Creek' ,`TaxAmount` = '7643' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779144' WHERE `Matrix_Unique_ID` = '211349180' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:24:52.820' ,`MLSNumber` = '81268073' ,`ListAgentFullName` = 'Rose Nava' ,`ListOfficeName` = 'JEA Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.779346' ,`Longitude` = '-95.197920' ,`PhotoCount` = '47' ,`PostalCode` = '77015' ,`RoomCount` = '6' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Emporia' ,`StreetNumber` = '12902' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1106' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS 3 BEDROOM 1.5 BATH CORNER LOT HOME IS LOCATED IN THE HOME OWNED ESTATES SUBDIVISION. FEATURES INCLUDE A COVERED FRONT PORCH, LIVING ROOM AND KITCHEN WITH BREAKFAST ROOM. MASTER BEDROOM WITH HALF BATH, INTERIOR UTILITY, LAMINATE FLOORING, ROOF (2 YEARS OLD), AC (2 YEARS OLD), GRANITE COUNTER TOPS, NEW WINDOWS (2 YRS OLD), NEW DRIVEWAY, COVERED CARPORT WITH EXTENDED DRIVEWAY FOR 6 CARS, 4 CAR GARAGE - ONE ATTACHED AND ONE DETACHED. FRESH PAINT THROUGHOUT, STAINLESS STEEL APPLIANCES, STANDUP SHOWER AND WIRED FOR SECURITY CAMERA. A MUST SEE. AT THIS PRICE, IT WON\'T LAST.' ,`Acres` = '0.2079' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1633 BLK 59 HOME OWNED ESTATES SEC 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9054' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Home Owned Estates Sec 05' ,`TaxAmount` = '3881' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779145' WHERE `Matrix_Unique_ID` = '211371845' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:44:26.677' ,`MLSNumber` = '54336506' ,`ListAgentFullName` = 'Mark Sonnier' ,`ListOfficeName` = 'George E. Johnson Properties' ,`SellingAgentFullName` = 'Jenny Martinez' ,`SellingOfficeName` = 'Vive Realty LLC' ,`Latitude` = '29.671437' ,`Longitude` = '-95.346309' ,`PhotoCount` = '21' ,`PostalCode` = '77033' ,`RoomCount` = '7' ,`ListPrice` = '190000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Ridgeway' ,`StreetNumber` = '5110' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you\'re a potential homeowner or investor looking for rental property, this home is for you! Home includes granite countertops, luxury vinyl flooring, mosaic backsplash, ceramic tiled tub surround, granite vanities and carport. Location is convenient to Medical Center, Pearland, The Galleria, Downtown and Hobby Airport. MEASUREMENTS ARE ESTIMATES - RE-MEASURE IF IMPORTANT.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 9 INWOOD TERRACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6270' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunnyside Courts' ,`TaxAmount` = '3905' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779145' WHERE `Matrix_Unique_ID` = '211404971' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:30:48.903' ,`MLSNumber` = '90479856' ,`ListAgentFullName` = 'Jane Draughon' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.147366' ,`Longitude` = '-95.478713' ,`PhotoCount` = '40' ,`PostalCode` = '77380' ,`RoomCount` = '10' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Timberwagon' ,`StreetNumber` = '10712' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3887' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique updated French style home in the heart of The Woodlands. Exquisite finishes and architectural details throughout with beautiful double iron front doors. The raised grand entry descends to the family room, featuring a spectacular fireplace which extends to the ceiling, surrounded by tall, elegant arched windows. The home features double pane energy efficient Anderson windows throughout, gorgeous updated hardwood floors, and a workshop with A/C. The lifetime Mansard roof shakes, metal stair balusters, stainless steel appliances, custom cabinets and granite kitchen and bath countertops are a few of the upgrades. Game room could also be second primary ensuite bedroom. The remodeled primary bath has a huge walk-in shower, custom cabinets with quartz countertops, and new fixtures, toilet & lighting. The downstairs primary bedroom, with it\'s own cozy fireplace, has a gorgeous view of the huge, picturesque backyard oasis with multi-level decking for relaxing under the canopy of trees.' ,`Acres` = '0.4886' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL GROGANS ML 06, BLOCK 6, LOT 20' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '21283' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAM HAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'Wdlnds Village Grogans Ml 06' ,`TaxAmount` = '7924' ,`TaxRate` = '2.0469' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779145' WHERE `Matrix_Unique_ID` = '211414642' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:16:28.460' ,`MLSNumber` = '42052482' ,`ListAgentFullName` = 'Nina Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514644' ,`Longitude` = '-95.478786' ,`PhotoCount` = '17' ,`PostalCode` = '77545' ,`RoomCount` = '5' ,`ListPrice` = '302990.00' ,`Status` = 'Active' ,`StreetName` = 'Natchez' ,`StreetNumber` = '4943' ,`StreetSuffix` = 'Trace' ,`City` = 'Arcola' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton\'s NEW community, POST OAK POINTE, IS NOW OPEN! Just off Hwy 6, shopping, dining, & entertainment are minutes away! Nearby Ft Bend Tollroad & Hwy 288 offers easy commuting to downtown, Galleria & Pearland and zoned to highly-acclaimed FBISD schools. Post Oak Pointe offers unique FARMHOUSE & MODERN exteriors with TONS of standard features- Smart home technology, Granite in kitchen & bathrooms, 42\" cabinets, front & back sod w/sprinklers, tankless water heater. This ONE-STORY CADEN plan features 3 bedrooms, 2 baths, formal dining, an oversized covered patio & 2 car garage. Future amenities in POST OAK POINTE will include an onsite Middle School planned for 2024, a lap pool, splash pad & large playscape. An AMAZING OPPORTUNITY to live in a beautiful community at LIMITED introductory prices! Schedule an appointment today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single 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` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Post Oak Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.25' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664779145' WHERE `Matrix_Unique_ID` = '211594103' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:16:05.137' ,`MLSNumber` = '58182837' ,`ListAgentFullName` = 'Nina Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514644' ,`Longitude` = '-95.478786' ,`PhotoCount` = '14' ,`PostalCode` = '77545' ,`RoomCount` = '5' ,`ListPrice` = '298990.00' ,`Status` = 'Active' ,`StreetName` = 'Natchez' ,`StreetNumber` = '5003' ,`StreetSuffix` = 'Trace' ,`City` = 'Arcola' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1409' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton\'s NEW community, POST OAK POINTE, IS NOW OPEN! Just off Hwy 6, shopping, dining, & entertainment are minutes away! Nearby Ft Bend Tollroad & Hwy 288 offers easy commuting to downtown, Galleria & Pearland and zoned to highly-acclaimed FBISD schools. Post Oak Pointe offers unique FARMHOUSE & MODERN exteriors with TONS of standard features- Smart home technology, Granite in kitchen & bathrooms, 42\" cabinets, front & back sod w/sprinklers, tankless water heater. This ONE-STORY BAXTOR plan features 3 bedrooms, 2 baths, formal dining, an oversized covered patio & 2 car garage. Future amenities in POST OAK POINTE will include an onsite Middle School planned for 2024, a lap pool, splash pad & large playscape. - An AMAZING OPPORTUNITY to live in a beautiful community at LIMITED introductory prices! Schedule an appointment today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single 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` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Post Oak Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.25' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664779145' WHERE `Matrix_Unique_ID` = '211618365' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:01:06.090' ,`MLSNumber` = '37934803' ,`ListAgentFullName` = 'Pamela Adkins' ,`ListOfficeName` = 'Central Metro Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.871928' ,`Longitude` = '-95.656497' ,`PhotoCount` = '40' ,`PostalCode` = '77084' ,`RoomCount` = '5' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Brookside Willow' ,`StreetNumber` = '16331' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3385' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**PRICE REDUCED** This spacious two-story home is available in the Bear Creek South area and located in Sommerall Park zoned to Cy-Fair ISD. Built in 2016, the first floor primary bedroom has en-suite that features dual separate vanities, soaking tub and two walk in closets. Enjoy watch parties in the over-sized game room located on the second floor flanked by four bedrooms with walk-in closets and two bathrooms. This popular floor plan has nice sized backyard and covered patio. Become a resident in this well maintained and quiet neighborhood with easy access to Hwy 6 and FM 529. Located near dining, shopping and main roads to I-10/Katy Fwy, 290, Beltway 8 and Grand Parkway/99. Schedule a showing today!' ,`Acres` = '0.1587' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 2 SOMMERALL PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6914' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HOLMSLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sommerall Park' ,`TaxAmount` = '7953' ,`TaxRate` = '2.641' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779146' WHERE `Matrix_Unique_ID` = '211790093' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:57:05.483' ,`MLSNumber` = '14468092' ,`ListAgentFullName` = 'Amanda Wilder' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799852' ,`Longitude` = '-95.482999' ,`PhotoCount` = '32' ,`PostalCode` = '77055' ,`RoomCount` = '10' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = 'Johanna' ,`StreetNumber` = '1629' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2590' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully maintained Sandcastle home with first floor living, a lovely outdoor space, and a designated extra parking spot! This 3 bedroom, 2.5 bathroom home was recently painted and all carpet was replaced. The kitchen is bright and spacious with a HUGE pantry! The outdoor space has a gorgeous pergola along with a yard perfect for your little one or pet (or both!). All bedrooms and the laundry room are located on the second floor. There is also a large game room with built-in bookshelves on the second floor. The air conditioner condenser and coil were replaced in August 2022. Washer, dryer, and refrigerator will stay with the home! In the back of the community there is a conveniently located pet run! Check out this beautiful home today!' ,`Acres` = '0.0795' ,`Area` = '24' ,`BuilderName` = 'Sandcastle' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 MELODY OAKS 9TH PAR R/P & EXTN AMEND' ,`LotDesciption` = 'Corner' ,`LotSize` = '3465' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TREASURE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Melody Oaks Pt Rep 9 & Ext' ,`TaxAmount` = '10987' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779146' WHERE `Matrix_Unique_ID` = '211819575' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:54:52.310' ,`MLSNumber` = '49987368' ,`ListAgentFullName` = 'Rainy Rawls' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = 'Emilia Herrera Linares' ,`SellingOfficeName` = 'Century 21 Realty Partners' ,`Latitude` = '29.946245' ,`Longitude` = '-95.143831' ,`PhotoCount` = '35' ,`PostalCode` = '77532' ,`RoomCount` = '8' ,`ListPrice` = '239000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Canyon Cove' ,`StreetNumber` = '18406' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1613' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect home for a first-time buyer or Vacation home. This 3 bedroom, 2 bath Fully fenced backyard, storage shed, and covered screened in patio has plenty of back and side yard space! The interior plan offers a spacious family room w/ adjacent dining area, fireplace, western style kitchen w/ breakfast bar, utility in-home at garage entry, and a split bedroom plan with good-sized rooms. The location is quiet and relaxing and blocks away from the lake. \r\nCome and see a one of a kind home in Lake Shadows that has great access to Lake Houston. Close to FM 1960 with dining and shopping, IAH, and Sam Houston Toll. This is the home for you, don\'t loose the opportunity, come see it today!' ,`Acres` = '0.2571' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 6 LAKE SHADOWS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Shadows Sec 01' ,`TaxAmount` = '4493' ,`TaxRate` = '2.6843' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779146' WHERE `Matrix_Unique_ID` = '211858810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:49:52.027' ,`MLSNumber` = '74867043' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.746151' ,`Longitude` = '-95.512334' ,`PhotoCount` = '31' ,`PostalCode` = '77320' ,`RoomCount` = '4' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Simmons' ,`StreetNumber` = '3001' ,`StreetSuffix` = 'Street' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2096' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This pristine 4/2.5 1-story home is priced to sell and won\'t last long! The family room boasts a brick wood burning fireplace, hardwood floors, and an open concept that seamlessly transitions into the breakfast room and kitchen area. The kitchen boasts granite countertops, a gas cooktop, double ovens, breakfast bar and ample cabinetry and counter space. The primary bedroom is oversized and flaunts a private en-suite bath and a vanity area. Additionally, one of the secondary bedrooms features a half bath + built-in shelving. Exterior features include 0.4 acres of cleared and unrestricted land, 2-car detached garage, and partial fencing. Recent upgrades also include a new AC unit, ducts, etc. This home is priced to sell and won\'t last long. Schedule a private tour today!' ,`Acres` = '0.4' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BOBO F (A-74), TRACT 30.1, ACRES .4' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '17424' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SCOTT JOHNSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '2864' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779146' WHERE `Matrix_Unique_ID` = '211865810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:38:27.430' ,`MLSNumber` = '35740117' ,`ListAgentFullName` = 'Norma Ramos' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072733' ,`Longitude` = '-95.564757' ,`PhotoCount` = '39' ,`PostalCode` = '77375' ,`RoomCount` = '10' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Cheslyn' ,`StreetNumber` = '9419' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2422' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impressive & Move In Ready! One-story home with a swimming pool In a desirable community of Inverness Estates.This home opens to dramatic crown molded ceilings & beautiful flooring throughout.This light & bright open floor plan boasts a study/flex room, perfect for a home office, Elegant formal dining area. The open kitchen & living area are perfect for entertaining/family gatherings.Amazing chef\'s kitchen w/abundant cabinetry & silestone counters; Family room features a gas log fireplace;Spacious Primary Suite includes a sitting area, Primary bathroom features separate raised sinks, a jetted tub, & separate shower, walk-in closets; Detached 3 Car Garage(side by side).The 4 sided- brick exterior with a covered front porch, covered patio behind garage with custom bar; Bonus features: The 24K Generator that provides electricity for the entire house, pool & garage; Sprinkler System with automatic Rain Gauge; Inverness Estates is off of the Grand Pkwy & offers easy access. Must See Today!' ,`Acres` = '0.2152' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 4 INVERNESS ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MAHAFFEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Inverness Estates Sec 02' ,`TaxAmount` = '7804' ,`TaxRate` = '3.0565' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779146' WHERE `Matrix_Unique_ID` = '211889715' --> 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','211953282','1664779146','211953282','2022-10-02T20:38:03.763','93060581','Melanie Curtis','Realty Associates','','','29.982606','-95.469419','15','77014','4','210000.00','Active','STRONG WINDS','3354','Drive','Houston','2','0','3','1240','Single-Family','COZEY 3 BEDROOM TWO BATH WITH RECENT INTERIOR and Exterior PAINT. UPDATED FLOORING, AND BATHROOMS. New Fencing Being INSTALLED / LIGHT & BRIGHT WITH PLENTY OF WINDOWS. PERFECT STARTER HOME. HOME IS WAITING FOR THE PERFECT BUYER TO COME ADD THEIR PERSONAL TOUCHES. WASHER & DRYER REMAIN. \r\n NEW EXTERIOR PAINT & FENCE','','13','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','0','1960/Cypress Creek South','Central Electric,Central Gas','1','LT 30 BLK 2 SABLECHASE SEC 4 PH2','Subdivision Lot','','','','315','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','48 - Spring','DELORAS E THOMPSON ELEMENTARY SCHOOL','WESTFIELD HIGH SCHOOL','EDWIN M WELLS MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Builder','1','Traditional','SABLECHASE','','','Public Sewer','1999','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:37:40.633' ,`MLSNumber` = '58871856' ,`ListAgentFullName` = 'Gift Duffield' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = 'Trish Gibbs' ,`SellingOfficeName` = 'White Label Realty' ,`Latitude` = '29.537848' ,`Longitude` = '-95.042239' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '10' ,`ListPrice` = '359900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Hollow Reef' ,`StreetNumber` = '2117' ,`StreetSuffix` = 'Circle' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Dream home alert! Tastefully updated two stories home with attached two cars garage on a cul-de-sac. Welcome your friends and family to your HGTV worthy home with dining room that opens to flex space so you can host any party size. Enjoy cooking in your spacious kitchen with walk-in pantry, lots of cabinet storage, \'22 Stainless Steel Sink and faucet upgrades, and durable and easy to clean seamless countertop-backsplash combo. All bedrooms are upstairs with great closets. Primary bedroom is huge with relaxing spa-like primary bathroom (Over $30K update in \'21.) 2018 & 2019 HVAC, \'20 Flooring upgrades in most rooms, \'22 Paint. Storm doors, Double panes windows, Hardi Planks siding. Lights fixtures and doorknobs are recently updated. Great size fenced in yard and patio. Well-established mature trees neighborhood with great amenities (Pools, parks, playground, jogging trails) & LOW TAXES (No MUD) CCISD schools. Per sellers, home never flooded, didn’t lose power during ’21 winter storm.' ,`Acres` = '0.1649' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 M MULDOON SUR LOT 50 BLK 1 HARBOUR PARK SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7182' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '605' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Harbour Park Sec 4 91' ,`TaxAmount` = '5251' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779146' WHERE `Matrix_Unique_ID` = '212133716' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:14:11.387' ,`MLSNumber` = '46317459' ,`ListAgentFullName` = 'Zachary Velky' ,`ListOfficeName` = 'Grassroots Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.325406' ,`Longitude` = '-94.942490' ,`PhotoCount` = '25' ,`PostalCode` = '77563' ,`RoomCount` = '10' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Ling' ,`StreetNumber` = '398' ,`StreetSuffix` = 'Street' ,`City` = 'Bayou Vista' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious, open floor plan. Upstairs has large kitchen with plenty of storage and living room with retro-style fireplace. Guest bedrooms and guest bath. Downstairs master suite. Huge bedroom with patio doors into backyard. Master bathroom with spa tub, shower, double vanity, and large combined closet and laundry room. On the best side of canal for afternoon shade. Front and back upstairs decks so you can enjoy the sunrise and sunset. Screened porch in front. Garage with separate room, great for workshop/tackle room. Set up for you to move in and enjoy right away and live as is. Also room for renovation/construction upside, rare deal in hot Bayou Vista. Recent bulkhead and dock.' ,`Acres` = '0.0976' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Gas,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 PAGE 7 LOT 398 NEW BAYOU VISTA ADDN 3' ,`LotDesciption` = 'Cul-De-Sac,Water View,Waterfront' ,`LotSize` = '4250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'New Bayou Vista 3' ,`TaxAmount` = '7325' ,`TaxRate` = '2.634' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779147' WHERE `Matrix_Unique_ID` = '212136834' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:25:14.800' ,`MLSNumber` = '52770699' ,`ListAgentFullName` = 'Christopher Mackoy' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.212703' ,`Longitude` = '-95.423173' ,`PhotoCount` = '45' ,`PostalCode` = '77385' ,`RoomCount` = '12' ,`ListPrice` = '424900.00' ,`Status` = 'Active' ,`StreetName` = 'Valance' ,`StreetNumber` = '9967' ,`StreetSuffix` = 'Way' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4065' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tucked in on a quiet cul-de-sac next to a green belt is this beautiful home. High ceilings and formal living/study greets you as you enter. Continuing into the home, there is new ceramic tile in the open formal dining and family room area with a gaslog fireplace. The spacious kitchen with tall cabinets completes the open concept this home brags. The first floor primary bedroom hosts a private en-suite bathroom with soaking tub, separate shower, and walk-in closet. Upstairs is extremely spacious with a large gameroom, media room, and study/exercise room with private balcony. New roof with transferrable warranty 2022. New ceramic on first floor completed in 2022.' ,`Acres` = '0.1656' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S720805 - MONTGOMERY CREEK RANCH 05, BLOCK 5, LOT 5' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7212' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Creek Ranch 05' ,`TaxAmount` = '8595' ,`TaxRate` = '2.6088' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664779147' WHERE `Matrix_Unique_ID` = '212143930' --> 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','212186093','1664779147','212186093','2022-10-02T20:54:05.557','10029127','Jijimon John','MIH REALTY, LLC','','','29.700369','-95.746160','6','77407','4','372500.00','Active','Tallow Knoll','7038','Lane','Richmond','2','1','4','2525','Single-Family','','0.1464','37','','','','','Sellers Disclosure','','','2','Fort Bend County North/Richmond','Central Gas','1','LAKEMONT SEC 2, BLOCK 3, LOT 13','Subdivision Lot','6376','Appraisal District','','700','0','','2','','0','','','','','Tile,Wood Shingle','33 - Lamar Consolidated','MCNEILL ELEMENTARY SCHOOL','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Craftsman','Lakemont Sec 2','6624','2.8215','Public Sewer,Public Water,Water District','2003','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212259384','1664779147','212259384','2022-10-02T21:33:02.280','7445504','Jessica Giraldo','eXp Realty, LLC','','','29.702327','-95.783217','48','77494','5','345000.00','Active','Cansfield','23627','Way','Katy','3','0','4','1841','Single-Family','IMMACULATE 4Bed & 3Full bath one story home in the prestigious HICKORY CREEK Subdivision. As you enter this beautiful bright home, SPOTLESS large open concept Living Room, Dining Room and a STUNNING Kitchen that features soft closing cabinets with QUARTZ Countertops, LG SS appliances & a bright breakfast area. FANTASTIC LED Ceiling lights. Family room includes a GORGEOUS fireplace for those cozy winter evenings. NO CARPET. AMAZING private fenced backyard, the PERFECT spot to entertain family and friends, Spacious enough to host any special event. It features a deck, a Pergola with a living room area, TV connection and an outdoor BBQ kitchen. Water Softener System, LG Fridge, LG washer/dryer come with the home. GREAT LOCATION Shopping, dining, & entertainment venues min away. Conveniently located next to westpark & 99. AWARD WINNING KATY SCHOOL DISTRICT. Zoned to #1 Katy HS Seven Lakes (2022). Never Flooded.','0.17','36','','','Electric Dryer Connections','','HOA First Right of Refusal,Mud,Owner/Agent,Sellers Disclosure','1','Freestanding,Gas Connections','1','Katy - Southwest','Central Electric','1','HICKORY CREEK SEC 3, BLOCK 2, LOT 6','Subdivision Lot','7404','Appraisal District','','212','0','','2','Convection Oven,Electric Oven','0','','','Gas Cooktop','','Wood Shingle','30 - Katy','HOLLAND ELEMENTARY SCHOOL (KATY)','SEVEN LAKES HIGH SCHOOL','BECKENDORFF JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Hickory Creek Sec 3','5230','2.5145','Water District','1995','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:59:21.327' ,`MLSNumber` = '989522' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.687291' ,`Longitude` = '-95.714176' ,`PhotoCount` = '38' ,`PostalCode` = '77407' ,`RoomCount` = '10' ,`ListPrice` = '569041.00' ,`Status` = 'Active' ,`StreetName` = 'Hampden Meadow' ,`StreetNumber` = '17906' ,`StreetSuffix` = 'Circle' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3254' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REPRESENTATIVE PHOTOS ADDED. October Completion! The Cabernet in Grand Vista is an entertainer’s dream! Perfectly sized the home features five bedrooms, three and a half baths, a study, game room, and three car garage. The open concept layout has dining area, island kitchen, and great room flow seamlessly together to comfortably fit all your guests. With a courtyard and covered patio there is also plenty of space to dine and relax outside. Retreat to the spacious first-floor owner\'s suite that is perfectly tucked away for privacy with a large walk-in closet and spa-inspired bath! Upstairs are three secondary bedrooms, two baths, and a huge game room! Structural options include: study, extended owner\'s suite, open railing, bedroom five downstairs, 8’ interior doors on first floor and covered outdoor living 1.' ,`Acres` = '0.29' ,`Area` = '37' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND VISTA SEC 18, BLOCK 3, LOT 4' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Other,Water View' ,`LotSize` = '12993' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Grand Vista 50s' ,`TaxAmount` = '' ,`TaxRate` = '2.52' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664779147' WHERE `Matrix_Unique_ID` = '212348008' --> 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','212438596','1664779147','212438596','2022-10-02T21:33:23.870','66643423','Mike Mahlstedt','Compass RE Texas, LLC','','','29.742793','-95.424184','38','77019','9','2695000.00','Active','Locke','3229','Lane','Houston','4','0','5','4260','Single-Family','This extensively remodeled home in River Oaks is both sophisticated and timeless with walkability to Houston\'s finest restaurants and shops. First floor features formals, guest suite and an impressive den with doors overlooking the backyard and new pool. No expense was spared in the chef\'s kitchen which opens to the large den. Only the finest materials were selected including designer lighting & hardware, impressive marbles & tiles. The 2nd floor features 4 additional bedrooms including the primary suite offers high-ceilings, expansive spa-like bath & an impressive, boutique style closet. The brand new pool with spa is surrounded by stunning landscaping including turf around the pool and rows of Holly trees - creating a beautiful privacy hedge. A detached studio or guest quarters is just off the pool. The indoor/outdoor flow is perfect for entertaining. This is an incredible opportunity to get into this special pocket of River Oaks.','0.1895','16','','','','','Sellers Disclosure','1','','2','River Oaks Area','Central Gas,Zoned','1','LT 4 BLK 24 RIVER OAKS SEC 4','Subdivision Lot','8255','Appraisal District','','1850','0','','1','','1','In Ground','','','','Composition','27 - Houston','RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)','LAMAR HIGH SCHOOL (HOUSTON)','LANIER MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','2','Traditional','River Oaks Sec 04','48641','2.3307','Public Sewer,Public Water','1936','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:13:48.180' ,`MLSNumber` = '88204043' ,`ListAgentFullName` = 'Roland Romero' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.126303' ,`Longitude` = '-95.565738' ,`PhotoCount` = '41' ,`PostalCode` = '77375' ,`RoomCount` = '11' ,`ListPrice` = '518000.00' ,`Status` = 'Active' ,`StreetName` = 'Mountclair Hollow' ,`StreetNumber` = '25102' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2446' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, David Weekly 1 story 3 br, 2.5 bath home with 3 car garage, with high ceilings, and upgrades throughout. Green belt location with no neighbors in back and on one side. The amazing island kitchen is the centerpiece of this home as it is open to overlook the breakfast and family rms, perfect for entertaining. The huge granite sitting island and upgraded cabinets with glass panels add to the function and beauty of the kitchen. The home boasts upgraded custom window treatments throughout. Carpeting in the bedrooms and upgraded tile in the rest of the home. The family rm is complete with a gas log fireplace. The primary bedroom has a primary bath with dbl vanities, over-sized walk-in shower with niches, and a lrg walk in closet. Utility rm and garage have additional cabinets. The covered, extended, travertine tiled, back patio, with TV, and wood burning fire pit are perfect for outdoor entertaining. Great location, with lakes, pool, clubhouse, playgrounds and walking paths.' ,`Acres` = '0.1808' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 4 LAKES AT CREEKSIDE SEC 3' ,`LotDesciption` = 'Corner,Greenbelt,Subdivision Lot' ,`LotSize` = '7875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TIMBER CREEK ELEMENTARY SCHOOL (Tomball)' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes at Creekside' ,`TaxAmount` = '9465' ,`TaxRate` = '2.784' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779147' WHERE `Matrix_Unique_ID` = '212454703' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:17:31.097' ,`MLSNumber` = '59533845' ,`ListAgentFullName` = 'Elizabeth Marshall' ,`ListOfficeName` = 'Global Advantage Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.228940' ,`Longitude` = '-95.443580' ,`PhotoCount` = '22' ,`PostalCode` = '77385' ,`RoomCount` = '4' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Glen Haven' ,`StreetNumber` = '700' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very large updated home, 4 bedroom, Formal Living and Dining Rooms,Ceramic floored Den with Fireplace and blower, Entry Hall, Updated kitchen, double ovens, dishwasher, quartz counters, stainless steel appliances, Beautiful updated baths, walk-in shower, vanity, wet bar, .40 acre lot, great for family, garden, play area, extra storage building, AND WATER WELL FOR ALL YOUR WATERING NEEDS. Public water and private water well. Stair lift installed on stairway. Formals could easily be converted to Mother-in-law suite, shower could be added to half bath downstairs. Beautiful engineered wood flooring in Master Suite, Extra large bedroom, lots of room with king size bed.' ,`Acres` = '0.4132' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S828600 - RIVERBROOK-FOREST HLS, LOT 85, 86-A' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '18000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverbrook-Forest Hls' ,`TaxAmount` = '1700' ,`TaxRate` = '2.3044' ,`WaterSewer` = 'Water District,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779147' WHERE `Matrix_Unique_ID` = '212486300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:07:48.930' ,`MLSNumber` = '58058748' ,`ListAgentFullName` = 'Sharon Gebhard' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.617266' ,`Longitude` = '-95.589220' ,`PhotoCount` = '48' ,`PostalCode` = '77478' ,`RoomCount` = '4' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'Bendwood' ,`StreetNumber` = '26' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home in desired Bendwood section of Sugar Creek on the golf course! This spacious well thought out home features tons of storage throughout. This home is perfect for entertaining. Gorgeous Austrian crystal chandelier in entryway. The living room features a built in fireplace and wet bar. Large kitchen and formal dining room. The bedrooms feature huge walk in closets and built ins. Main bedroom features a panick button that turns on all lights in the house. The third bedroom could serve as a home office. \r\n Enjoy the upper deck and downstairs patio. Lots of updates including electrical panel with whole house surge protector, new Gorilla Glass windows, new exterior doors, gas water heater with leak detector, and upgraded alarm system. Sheetrocked garage with built in cabinets. HOA fee includes mowing and edging. Schedule your showing today!' ,`Acres` = '0.1688' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 8, LOT 26' ,`LotDesciption` = 'On Golf Course' ,`LotSize` = '7354' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1259' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DULLES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Creek Sec 8' ,`TaxAmount` = '6483' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779148' WHERE `Matrix_Unique_ID` = '212548742' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:25:29.700' ,`MLSNumber` = '2632717' ,`ListAgentFullName` = 'Shawn Geiser' ,`ListOfficeName` = 'Texas Urban Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.040459' ,`Longitude` = '-95.239312' ,`PhotoCount` = '21' ,`PostalCode` = '77339' ,`RoomCount` = '5' ,`ListPrice` = '397000.00' ,`Status` = 'Active' ,`StreetName` = 'Mustang' ,`StreetNumber` = '1115' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2269' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained Contemporary home in the sought after Forest Cove Subdivision. This 3 bedroom, 2 bath, 1 story home with pool has only had 2 owners. Well maintained and updated for easy move in and enjoyment. This home has easy access to HWY 59/69, IAH, golf courses and restaurants. Home has never flooded.' ,`Acres` = '0.4304' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 91 BLK 42 FOREST COVE COUNTRY CLUB ESTATES SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '18750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '160' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Forest Cove Dountry Club Estates' ,`TaxAmount` = '7289' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779148' WHERE `Matrix_Unique_ID` = '212558399' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:11:58.757' ,`MLSNumber` = '76958867' ,`ListAgentFullName` = 'Maria Cortes' ,`ListOfficeName` = 'Anchor Realty Assoc., Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812633' ,`Longitude` = '-94.991763' ,`PhotoCount` = '17' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '285500.00' ,`Status` = 'Active' ,`StreetName` = 'Osage' ,`StreetNumber` = '4603' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2303' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELL MAINTAINED 4 Bedroom 2.5 bath home located in Meadow Lake. Spacious living & dining area with four bedrooms on second floor. Kitchen offers plenty of cabinets, large counter space, and breakfast nook. Primary Bedroom features high ceilings, primary bath with shower and separate garden tub. Two vanities and roomy walk-in closet. Two extra rooms on first floor could be used as office/study. Home has tile and Laminate Flooring throughout. Ceiling Fans, 2\'\' blinds throughout home. New AC/Heating and duct installed November 2021 + Fresh Exterior Paint.' ,`Acres` = '0.1716' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 4 MEADOW LAKE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadow Lake Sec 03' ,`TaxAmount` = '4796' ,`TaxRate` = '2.755' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779148' WHERE `Matrix_Unique_ID` = '212625268' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:14:39.423' ,`MLSNumber` = '67137716' ,`ListAgentFullName` = 'Rainy Rawls' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.950181' ,`Longitude` = '-95.725865' ,`PhotoCount` = '48' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'First Bend Drive' ,`StreetNumber` = '18319' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3452' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home located in highly Acclaimed Bridgeland!! This 4 Bdrm, 3.5 Baths has a backyard oasis, loaded with upgrades! This home flows beautifully from the moment you walk in the door, you will see a beautiful built in saltwater fish tank, spacious living area with lots of windows bringing in lots of natural lighting, beautiful stone fireplace,a large kitchen loaded with lots of cabinetry,island featuring granite counters. Kitchen opens into Brkfst area & Living area w/ long bar, a Study/w French doors, built in computer station downstairs and dual stations upstairs. Primary bdrm has bay windows, ensuite bath and large closet space. Upstairs you will find a Large gameroom and Media room that comes fully equipped with projector, speakers and huge screen. The backyard oasis is perfect for entertaining, including oversized patio, New pool installed in 2021, plumbing for outdoor bthrm installed, and beautiful Pergola by the pool. This is the home you\'ve been waiting for!Come see today!' ,`Acres` = '0.153' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 FIRST BEND SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6663' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1255' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '12114' ,`TaxRate` = '3.4329' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779148' WHERE `Matrix_Unique_ID` = '212655332' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:49:32.103' ,`MLSNumber` = '13559284' ,`ListAgentFullName` = 'Ana Reyna' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.404576' ,`Longitude` = '-95.426250' ,`PhotoCount` = '26' ,`PostalCode` = '77378' ,`RoomCount` = '5' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Camp Creek' ,`StreetNumber` = '11221' ,`StreetSuffix` = 'Way' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '1632' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living at its best. Double wide mobile home sitting on over an acre. 5 Bedrooms and 3 full Bathrooms, Kitchen has lots of counter and cabinet space. Large living room great for entertaining. and Huge front porch.' ,`Acres` = '1.0304' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CREEKSIDE ACRES 01, BLOCK 2, LOT 7' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '44884' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside Acres 01' ,`TaxAmount` = '381' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664779148' WHERE `Matrix_Unique_ID` = '212699033' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:28:50.723' ,`MLSNumber` = '77380768' ,`ListAgentFullName` = 'Joauna Tuck' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.404553' ,`Longitude` = '-95.797151' ,`PhotoCount` = '47' ,`PostalCode` = '77461' ,`RoomCount` = '3' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Alex' ,`StreetNumber` = '10503' ,`StreetSuffix` = 'Drive' ,`City` = 'Needville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1692' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COME HOME TO THE COUNTRY!! This 4 bedroom is located on one of largest lots in the neighborhood with over 1/2 acre. Interior has new carpet in bedroom. New title floors installed 2022, roof replaced Feb 2022 and new AC 2022. Very spacious primary bedroom with raised ceiling has 2 walk-in closets, large dual vanity in bath. The extra large backyard with pool allows room for anything you wish! Propane tank is underground. Priced to sell fast and AS-IS!!!!!' ,`Acres` = '0.675' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ROSEMEADOW SEC 3, BLOCK 6, LOT 7' ,`LotDesciption` = 'Corner' ,`LotSize` = '29402' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Rosemeadow Sec 3' ,`TaxAmount` = '3959' ,`TaxRate` = '1.8957' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779149' WHERE `Matrix_Unique_ID` = '212710673' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:22:22.897' ,`MLSNumber` = '88068544' ,`ListAgentFullName` = 'Damon Welborn' ,`ListOfficeName` = 'Threshold Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.909177' ,`Longitude` = '-95.598377' ,`PhotoCount` = '18' ,`PostalCode` = '77065' ,`RoomCount` = '5' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Flaxen' ,`StreetNumber` = '12130' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1381' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house is a Steeplechase gem! Great curb appeal. Upgraded triple pane windows keep bills extremely low per Seller & look sharp. Home is nice, neutral and ready to go whether starting out, downsizing, or looking for a strong investment property. Home lives large thanks to massive living room, featuring a cozy gas fireplace, that opens to foyer, dining, and kitchen, where you\'ll find gas cooking and loads of refinished kitchen cabinets. Hard surfaces everywhere except bedrooms, where you\'ll find brand new carpet. Fully remodeled Primary Bath is a sweet retreat. Second / guest bath features brand new wood-like tile. Fresh paint throughout the interior. Tasteful professional landscaping make for great curb appeal and provide a serene spot to relax in the backyard. 2 car garage for your cars, tools, and toys. Street is well maintained and pride of ownership is evident. Easy access to 290, Beltway, and 99. Award winning Cy-Fair district. Here\'s your chance to live BIG on a LITTLE budget!' ,`Acres` = '0.1768' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 61 BLK 4 STEEPLECHASE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '610' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'EMMOTT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Steeplechase Sec 04' ,`TaxAmount` = '4179' ,`TaxRate` = '2.541' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779149' WHERE `Matrix_Unique_ID` = '212848810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:31:21.240' ,`MLSNumber` = '43478280' ,`ListAgentFullName` = 'Harry Lou' ,`ListOfficeName` = 'Fidelity Realtors and Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747482' ,`Longitude` = '-95.733850' ,`PhotoCount` = '40' ,`PostalCode` = '77450' ,`RoomCount` = '12' ,`ListPrice` = '669000.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden Shore' ,`StreetNumber` = '2422' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW FOORING. NEW WINDING STAIRCASE/HANDRAIL! NEW ROOF! NEW INTERIOR PAINTING! LOTS OF IMPROVEMENTS IN THIS ELOQUENT KELLIWOOD LAKES HOME! LAKE VIEW, 4 BEDROOMS AND 3.5 BATHS. HIGH CEILING STUDY, FORMALS, GAMEROOM UP, MASTER DOWN W/ BAY WINDOW. MASTER BATH W/ DUAL SINKS, GARDEN TUB WITH SEPARATE SHOWER. ISLAND KITCHEN. EXCELLENT KATY ISD SCHOOLS. TWO STAIRCASES, ROOF TOP DECK / BALCONY WITH LAKE VIEW. PORTE COCHERE FOR ADDITIONAL PARKING.' ,`Acres` = '0.2296' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 KELLIWOOD LAKES SEC 1 PAR R/P' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HAYES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kelliwood Lakes Sec 01' ,`TaxAmount` = '12473' ,`TaxRate` = '2.3333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779149' WHERE `Matrix_Unique_ID` = '212873174' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:52:35.760' ,`MLSNumber` = '19110957' ,`ListAgentFullName` = 'Karina De Los Reyes' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.043024' ,`Longitude` = '-95.528983' ,`PhotoCount` = '39' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Villa Mountain Lane' ,`StreetNumber` = '7039' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2162' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in the Twin Falls community; 4 BDS/2 BA with Granite & Marble countertops! Access to the community pool & walking trails around the lake. Study has built-in cabinets, can also be used as a craft room. Formal entry way leads to great open concept floor plan. Kitchen has granite countertops, SS appliances, gas range, glass tile backsplash, & it also features a breakfast nook w/quartz countertops & built-in cabinets. The breakfast bar looks into living area & kitchen. The Primary bedroom has an additional walk in closet! Enjoy the gas log fireplace for relaxation. Quaint front porch, head to the tiled back patio for privacy & enjoy your quiet backyard (no side neighbors on the patio side). 2 car garage w/epoxy floor painting. Mature landscaping, sprinkler system, low tax rate and NO FLOODING! In a fantastic location, easy access to 249 & close proximity to many restaurants & shopping! Call for a showing!' ,`Acres` = '0.1754' ,`Area` = '13' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 2 TWIN FALLS SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7642' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KUEHNLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Twin Falls' ,`TaxAmount` = '6319' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779149' WHERE `Matrix_Unique_ID` = '212876220' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:27:35.480' ,`MLSNumber` = '58823060' ,`ListAgentFullName` = 'Tami Davenport' ,`ListOfficeName` = 'Roy Shiflett, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.695220' ,`Longitude` = '-95.758223' ,`PhotoCount` = '24' ,`PostalCode` = '77407' ,`RoomCount` = '8' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Sabinal Creek' ,`StreetNumber` = '7423' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1809' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your New Home! This beautiful home features a large kitchen with a gas range, microwave and a new dishwasher! Granite countertops and tile backsplash; Tile floors in Entry, kitchen/Breakfast and wet areas; recently added laminate wood floors in the Family Room (2020); Cozy gas log Fireplace in Family Room; Study with French Doors; new carpet in all Bedrooms and Study; Primary Bath with double sink vanity and separate Shower and Garden Tub; Storm Door added to the Back Door leading to a large Patio area; Home built with Pex plumbing system; A/C Compressor (2018); Garage has a large workbench area and water softener hookups. No Flooding! Low Taxes! Easy access to Westpark Tollway and Grand Parkway! Call to view this property today!' ,`Acres` = '0.1352' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOST CREEK SEC 2, BLOCK 4, LOT 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5889' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '726' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ADOLPHUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lost Creek Sec 2' ,`TaxAmount` = '5561' ,`TaxRate` = '2.7615' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779149' WHERE `Matrix_Unique_ID` = '212919131' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:45:55.173' ,`MLSNumber` = '27852264' ,`ListAgentFullName` = 'Nona Marcel' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683452' ,`Longitude` = '-95.585598' ,`PhotoCount` = '32' ,`PostalCode` = '77099' ,`RoomCount` = '5' ,`ListPrice` = '249500.00' ,`Status` = 'Active' ,`StreetName` = 'Zarroll' ,`StreetNumber` = '11735' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1918' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming single story home located in Kirkwood Village offers 3 bedroom 2 bath. Small atrium at entry with sky light. The living room boast with TALL ceilings with Wood/Gas Fireplace and LOTS of natural light. The Kitchen with tons of Upgrades has island with stainless steel gas cooktop, GRANITE countertops, and Travertine floors. SPACIOUS Primary bedroom with French doors that offer TONS of natural light.Has walkin closet, ensuite bathroom with shower/tub combo, double vanity sinks NEW FAUCETS. Relax on the fully covered patio with FAMILY and FRIENDS. GREAT LOCATION! Coveniently located near grocery stores,resturaunts,and schools. Easy access to the Beltway 8 and HWY 59. Won\'t last long!' ,`Acres` = '0.1162' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 2 KIRKWOOD VILLAGE R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5060' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '235' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'BOONE ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'HOLUB MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Lockbox Left Side,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kirkwood Village R/P' ,`TaxAmount` = '4361' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779150' WHERE `Matrix_Unique_ID` = '212954978' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:05:41.880' ,`MLSNumber` = '63907367' ,`ListAgentFullName` = 'Penny Ngo' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Alison Hill Smith' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.861769' ,`Longitude` = '-95.626399' ,`PhotoCount` = '37' ,`PostalCode` = '77084' ,`RoomCount` = '7' ,`ListPrice` = '189900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cinnamon Creek' ,`StreetNumber` = '5935' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate home located in Charlestown Colony with close acces to major thoroughfares such as West Little York, Eldridge and Hwy 6. New paint inside and outside of the home with engineering oak wood flooring on most of first floor plus on the stairway and water resistant laminated floors in the bedrooms and secondary bathroom! New tile flooring in primary bath. Wash, dryer and refrigerator stays! The home is right next to the community playground. The first floor boasts an open design with a half bath, a fireplace and direct access to the kitchen. The wrap around gated backyard has plenty of space and the home is equipped with gutters all around (2 years). This home has never flooded. The home\'s windows and sky light make for a light and bright atmosphere throughout the day. All windows are equipped with solar screens to reduce heat while providing privacy. The home also offers: a formal dining and breakfast area, quartz kitchen countertops, indoor utility closet and much more!' ,`Acres` = '0.0643' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 1 CHARLESTOWN COLONY SEC 1' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '336' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`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` = 'Charlestown Colony Sec 01' ,`TaxAmount` = '3451' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779150' WHERE `Matrix_Unique_ID` = '212956563' --> 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','212965054','1664779150','212965054','2022-10-02T21:44:19.453','22655709','Mia Cardenas','Keller Williams Premier RealtyKaty','','','29.556807','-95.238820','43','77581','12','357000.00','Active','Pine Cone','2704','Lane','Pearland','2','1','3','2249','Single-Family','Beautiful home nestled in the quiet, wooded community of Pine Shadows with 3 bedrooms and 2.5 baths. Large windows allow natural light to fill the home and highlight the spaciousness of each room. Step into the grand living room featuring cathedral ceilings and a stately brick fireplace. An open kitchen with granite counters and stainless appliances connects to the breakfast area. The formal dining room is located just off the front entry. A generously sized primary suite has cathedral ceilings and huge windows that overlook the private backyard full of beautiful trees. The primary bath offers double sinks with vanity, an oversized shower and 2 walk-in closets. Secondary bedrooms located upstairs are spacious. Upstairs also offers a large living area, study and full bath. A large gameroom was added downstairs, along with a half bath. Pine Shadows community is NOT managed by an HOA and no MUD tax! LOW tax rate! The home is an estate and being sold AS IS. Move in ready!!!','0.2101','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Pearland','Central Electric','0','PINE SHADOWS (PEARLAND), BLOCK 2, LOT 10','Subdivision Lot,Wooded','9152','Appraisal District','','0','0','','0','Electric Oven','0','','','Electric Cooktop','','Composition','42 - Pearland','SHADYCREST ELEMENTARY SCHOOL','PEARLAND HIGH SCHOOL','PEARLAND JUNIOR HIGH EAST','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Pine Shadows Pearland','7232','2.5552','Public Sewer,Public Water','1979','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','212990790','1664779150','212990790','2022-10-02T21:53:00.893','74416168','Jomon Kannala','Keller Williams Signature','','','29.551002','-95.521024','48','77459','8','379900.00','Active','Anzio','2322','Court','Missouri City','2','0','3','2072','Single-Family','~ LAKEFRONT - 1-Story, 2019 home, built by Princeton Classic Homes *PLEASE MAKE APPOINTMENT* Very lightly used; enjoy your elegant, open concept designed home with wood floors and volume height ceilings in an established lakefront community featuring resident fishing and permitted small boating activities. On the lake with enclosed fence (HOA fishing available, small boating permitted in the lake) - open kitchen/living space (viewing the lake!) – open, relaxing breakfast area (viewing the lake!) - covered patio - upgraded gas stub at the covered patio for grilling - pre-wired alarm system wiring throughout at home doors/windows - gas fireplace - sprinkler system front/backyards installed - mudroom area - upgraded countertops in kitchen & primary bathroom - bay window in the primary bedroom (lake views!) - spacious 2-car garage','0.164','38','Princeton Classic','','','','Sellers Disclosure','','','','Missouri City Area','Central Electric,Central Gas','1','LAKE SHORE HARBOUR SEC 7, BLOCK 1, LOT 84','Cul-De-Sac,Waterfront','7144','Appraisal District','','1100','0','','2','','0','','','','','Composition','19 - Fort Bend','PALMER ELEMENTARY SCHOOL (FORT BEND)','HIGHTOWER HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','Accompany,Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','1','Ranch','Lake Shore Harbour Sec 7','8896','3.18','Public Sewer,Public Water','2019','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:37:54.030' ,`MLSNumber` = '29159407' ,`ListAgentFullName` = 'George Chiamos' ,`ListOfficeName` = 'Royce Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.081543' ,`Longitude` = '-95.517867' ,`PhotoCount` = '27' ,`PostalCode` = '77388' ,`RoomCount` = '4' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Colter Stone' ,`StreetNumber` = '21703' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home sits on a cul-de-sac in the highly sought after Northcrest Village subdivision. It boasts an oversized backyard for uses limited only by your imagination. A big feature of this home is its large kitchen with lots of cabinet space and an island that comfortably seats 4. The pantry is a huge 11‘x 6’ storage area for dry goods and \r\n much more. \r\nThe formal dining room is currently utilized as a media room with its own screen. One of the secondary bedrooms has additional storage areas. Additionally, there is extra space in the rear of the garage for many creative uses. Secure your Scheduled your showing soon to make it yours.' ,`Acres` = '0.2062' ,`Area` = '14' ,`BuilderName` = 'Beazer' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 NORTHCREST VILLAGE SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8983' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '520' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FOX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northcrest Village Sec 01' ,`TaxAmount` = '6290' ,`TaxRate` = '2.644' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779150' WHERE `Matrix_Unique_ID` = '212993679' --> 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','213010015','1664779150','213010015','2022-10-02T21:07:18.060','62416521','Joseph Khuat','KA Realty','','','29.886411','-95.480440','3','77088','3','109500.00','Active','Pincay Oaks','6031','Street','Houston','2','0','3','1738','Single-Family','This is the perfect home for any home investor. This home was damaged in a fire so you can rebuild it anyway you please.','0.1791','11','','','','','No Disclosures','1','','1','Northwest Houston','Central Electric','1','LT 9 BLK 2 017*I5645955-001-002-009 INWOOD NORTH SEC 1','Subdivision Lot','7800','Appraisal District','','','0','','2','Electric Oven','0','','','Gas Cooktop,Gas Range','','Aluminum','32 - Klein','NITSCH ELEMENTARY SCHOOL','KLEIN FOREST HIGH SCHOOL','KLEIN INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Inwood North Sec 01','3616','2.6055','Public Sewer,Water District','1976','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:38:02.753' ,`MLSNumber` = '61860618' ,`ListAgentFullName` = 'Paula Pinkney-Smith' ,`ListOfficeName` = 'Coldwell Banker RealtyThe Willis Office' ,`SellingAgentFullName` = 'Paula Sicardo' ,`SellingOfficeName` = 'CS Realty Associates' ,`Latitude` = '30.178495' ,`Longitude` = '-95.366998' ,`PhotoCount` = '10' ,`PostalCode` = '77302' ,`RoomCount` = '4' ,`ListPrice` = '130000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Walker' ,`StreetNumber` = '13865' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1049' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3/1 on just under one acre. Close to FM 242, Hwy 59 and 99 but with a county feel. Home is being sold AS Is but with just a little TLC could be the perfect starter home or investment property. Call today to schedule your showing, it wont last long' ,`Acres` = '0.97' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BENNETTE J O H-OWENS, LOT 82-D, ACRES 0.970' ,`LotDesciption` = 'Cleared' ,`LotSize` = '42253' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Bennette J O H-Owens' ,`TaxAmount` = '1845' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779150' WHERE `Matrix_Unique_ID` = '213024809' --> 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','213034066','1664779150','213034066','2022-10-02T20:20:17.623','23926985','Mai Banh','World Wide Realty','','','29.697491','-95.638232','38','77083','6','280000.00','Active','Pavilion','7319','Drive','Houston','2','0','3','1487','Single-Family','Lovely 1 story 3 beds 2 baths. High ceiling. Open kitchen with granite top. Bright living area. Located near Highway 6 and Bellaire Blvd. Near shopping center, 2 minutes to Fiesta and HEB. Near Hong Kong city mall and Chinatown. Call your agent to schedule a show. Don\'t miss it.','0.0945','28','','','','','Mud,Sellers Disclosure','','','','Alief','Central Gas','1','LT 15 BLK 1 TERRA DEL SOL SEC 5','Patio Lot,Subdivision Lot','4115','Appraisal District','','558','0','','2','','0','','','','','Composition','2 - Alief','HICKS ELEMENTARY SCHOOL (ALIEF)','AISD DRAW','ALBRIGHT MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Terra Del Sol','5320','2.5785','Public Sewer,Public Water,Water District','2016','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:25:20.067' ,`MLSNumber` = '59380167' ,`ListAgentFullName` = 'Celci Logue' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.949789' ,`Longitude` = '-95.726712' ,`PhotoCount` = '28' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Oak Bend' ,`StreetNumber` = '18322' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2314' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME! This beautiful single story home is located right next to the park in the Lakeland Heights section of Bridgeland! This gorgeous home features updated lighting throughout and plenty of natural light. Don\'t want your carpet to get dirty? Not a worry here, this home features Tile in the heavy traffic areas, Bamboo and Engineered Hardwoods in the bedrooms, office and dining rooms. There is also fresh paint throughout the home as well as a BRAND NEW remodeled Master Bathroom that is Stunning! Other features include a whole house water filtration and conditioning system, new kitchen sink, faucet and garbage disposal, tankless water heater, garage door opener, and custom touches and layout in the office (built-ins), laundry room and pantry. This home is turn-key ready, book your showing now because it won\'t last long! ' ,`Acres` = '0.1375' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 FIRST BEND SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5989' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Ranch,Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '9338' ,`TaxRate` = '3.4329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779150' WHERE `Matrix_Unique_ID` = '213042947' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:18:36.170' ,`MLSNumber` = '36639948' ,`ListAgentFullName` = 'Manuel Larios' ,`ListOfficeName` = 'Exceed Realty' ,`SellingAgentFullName` = 'Claudio Andrade' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '30.012219' ,`Longitude` = '-95.636140' ,`PhotoCount` = '42' ,`PostalCode` = '77429' ,`RoomCount` = '8' ,`ListPrice` = '313000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sac' ,`StreetNumber` = '13922' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A great home with many updates and upgrades in highly desired Village of Indian Trails located on a cul-de-sac. This home provides an open floorplan that makes it excellent for hosting and entertaining during holidays or any event. 3-bedroom split floorplan with an office and formal dining room. Beautiful master bath, with soaking tub and walk-in shower, double vanity plus a large walk-in closet. Waterproof Flooring, granite counter tops! Quick access to 249, 290 and 99.' ,`Acres` = '0.1257' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 43 BLK 1 VILLAGE OF INDIAN TRAILS SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Indian Trails Sec 02' ,`TaxAmount` = '6034' ,`TaxRate` = '2.7564' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779151' WHERE `Matrix_Unique_ID` = '213072060' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:26:01.553' ,`MLSNumber` = '49743656' ,`ListAgentFullName` = 'Kathy Griggs' ,`ListOfficeName` = 'Griffin Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.469429' ,`Longitude` = '-95.125585' ,`PhotoCount` = '16' ,`PostalCode` = '77573-2390' ,`RoomCount` = '9' ,`ListPrice` = '398900.00' ,`Status` = 'Active' ,`StreetName` = 'Sandvalley' ,`StreetNumber` = '2520' ,`StreetSuffix` = 'Way' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this well maintained home in highly desirable Brittany Lakes. Large living area with corner fireplace opens to the updated kitchen and HUGE dining area. Walk in pantry and stainless steel appliances. Nice study with French Doors is the perfect home office. Spacious primary bedroom, double sinks and separate shower in the primary bath, and a large walk-in closet. Enjoy spending time with your family in the TEXAS SIZED gameroom. Convenient inside utility room. Storage building out back. New roof Feb 2022. This home has so many extras and so much to offer your family. Low tax rate, CCISD, and great neighborhood amenities for your family to enjoy. Room sizes are estimates and verify all info.' ,`Acres` = '0.1612' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BRITTANY LAKES SEC 14 (2006) ABST 3, BLOCK 2, LOT 27, ACRES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAUERSCHLAG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brittany Lakes Sec 14 2006' ,`TaxAmount` = '6299' ,`TaxRate` = '2.2667' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779151' WHERE `Matrix_Unique_ID` = '213077524' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:39:34.353' ,`MLSNumber` = '71180763' ,`ListAgentFullName` = 'Jade Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829636' ,`Longitude` = '-95.689309' ,`PhotoCount` = '29' ,`PostalCode` = '77084' ,`RoomCount` = '4' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Wood Glen' ,`StreetNumber` = '18535' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pride in ownership shows at every turn on this lovely patio home in the established Wood Fern subdivision. Enter through the quant front courtyard, into the open living area with vaulted ceilings and a beautiful gas fireplace and kitchen layout is a chefs dream! Large master suite with french doors leading to the beautifully landscaped and newly fenced back yard. Complete remodel approximately 7 years ago including flooring, paint, fixtures, bathrooms, doors, etc. Roof approximately 6 years old, and A/C replaced approximately 6 years ago. This home is one of a kind! Call today to see for yourself!' ,`Acres` = '0.0993' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 WOOD FERN SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4324' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wood Fern Sec 01' ,`TaxAmount` = '3529' ,`TaxRate` = '2.587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779151' WHERE `Matrix_Unique_ID` = '213093224' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:46:05.270' ,`MLSNumber` = '10606489' ,`ListAgentFullName` = 'Lin Huang' ,`ListOfficeName` = 'KingFay Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.534720' ,`Longitude` = '-95.614543' ,`PhotoCount` = '46' ,`PostalCode` = '77479' ,`RoomCount` = '11' ,`ListPrice` = '960000.00' ,`Status` = 'Active' ,`StreetName` = 'Tarrion Bay' ,`StreetNumber` = '6610' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Mediterranean 2-story in gated section of the highly sought after Riverstone community. This large home meets all the needs of your family with 5 bedrooms (3 en-suite bedrooms), 4.5 bathrooms, and 3-car garage. Grand foyer showcases a spiral staircase and opens into an oversized dining room flanked by columns and complete with a butler\'s pantry. Impressive family room with two-story ceilings, corner fireplace and a wall of windows providing natural light. Fabulous open kitchen featuring a unique baby grand piano shaped island and large counter space. Unwind in primary bedroom, located on other side of family room. Pass through the bathroom doors and you will be transported to your own spa with large tub and walk-in shower. An en-suite guest bedroom is located on 1st floor. 2nd floor features 3 additional bedrooms, 2 full bathrooms, game room and media room. No back neighborh. Never flooded. Zoned to excellent Fort Bend ISD. Front door facing northeast.' ,`Acres` = '0.2482' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON AT RIVERSTONE SECTION 18-B, BLOCK 2, LOT 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10812' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1865' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Avalon At Riverstone Sec 18-B' ,`TaxAmount` = '16662' ,`TaxRate` = '2.4529' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779151' WHERE `Matrix_Unique_ID` = '213124714' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:18:37.800' ,`MLSNumber` = '15783482' ,`ListAgentFullName` = 'Gabriel Mendoza' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.481546' ,`Longitude` = '-95.148355' ,`PhotoCount` = '30' ,`PostalCode` = '77573' ,`RoomCount` = '11' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Carefree' ,`StreetNumber` = '1206' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1550' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. This beautiful 4 bed/2 bath home is ready for new owners! Bursting w/ natural light, this home has plenty of windows throughout that brighten up the living spaces. Hard surfaced floors in the living room & breakfast nook are perfect for an easy cleanup. A breakfast bar in the family room is ideal for snacks during a movie marathon or for easy conversations w/ the chef. The kitchen has ample counter space. The en-suite bath in the primary bedroom has a gorgeous standing shower & new countertops. 2 of the bedrooms have built-in shelving that is perfect for additional storage. Enjoying the sun comes easy w/ this spacious backyard. Spend the morning playing golf at the Magnolia Creek Golf Club or at Rustic Oaks Park! Close access to HWY 45 that leads to Galveston! Recent renovations include: new carpet throughout the home & new countertops in both bathrooms. Welcome home!' ,`Acres` = '0.282' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 9 J DICKINSON SUR LOT 42 BLK 3 COUNTRYSIDE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12284' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Countryside Sec 4' ,`TaxAmount` = '3695' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779151' WHERE `Matrix_Unique_ID` = '213131611' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:59:48.767' ,`MLSNumber` = '16559636' ,`ListAgentFullName` = 'Katia Hadjiyska' ,`ListOfficeName` = 'EnCourage Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.743634' ,`Longitude` = '-95.468886' ,`PhotoCount` = '41' ,`PostalCode` = '77056' ,`RoomCount` = '13' ,`ListPrice` = '1295000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Lake' ,`StreetNumber` = '5326' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2969' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Timeless 4-bedroom + detached flex, 3.5-bath, 1-story mid-century modern home, situated in Tanglewood area’s Del Monte, boasting plentiful natural light, modern finishes & eye-catching fixtures throughout. Art gallery walls adorned w/ custom tapestry, wood paneling & brick accents exude elegance, while oversized windows allow for serene views of one of the largest backyards in the subdivision complete w/ an expansive patio, functional freestanding air conditioned flex-use structure w/ carport, gated driveway w/ ample parking & an herb garden. This home impresses w/ an extended kitchen w/ a SS appliance package, farmhouse sink & peninsula island open to the breakfast area, a sizable formal dining, cozy game area & living w/ vaulted ceilings & a fireplace. Primary bedroom retreat w/ walk-in closet & en-suite bath w/ double sink vanity, walk-in shower & a spa tub. 3 secondary bedrooms & 2 full baths, one w/ a shower & one w/ a tub. Utility room w/ full size W/D & adjacent powder bath.' ,`Acres` = '0.368' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 & TR 6A ABST 693 C SAGE DEL MONTE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '23169' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Del Monte Sec 02 Rep' ,`TaxAmount` = '23638' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779152' WHERE `Matrix_Unique_ID` = '213156807' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:02:40.783' ,`MLSNumber` = '9136788' ,`ListAgentFullName` = 'Holly Kidwell' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.900311' ,`Longitude` = '-95.647951' ,`PhotoCount` = '26' ,`PostalCode` = '77095' ,`RoomCount` = '7' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Hot Springs' ,`StreetNumber` = '8311' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1902' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful home in Copperfield Middlegate Village looking for its next owner. Adorable 4 bedroom 2 full bathroom home on a cul-de-sac, features a great backyard with pool and screened in patio/porch. The home has a nice floor plan with lots of space for entertaining. Large formal dining and living room combo greet you as you enter. Extra recessed lighting was added along with 2-inch blinds. The kitchen and family room area is cozy and features a breakfast bar. The primary bedroom and bathroom features 2 sink areas and a vanity. Refrigerator, washer and dryer included! This home is waiting for you to fall in love with it!' ,`Acres` = '0.2264' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 54 COPPERFIELD MIDDLEGATE VILLAGE SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FIEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Copperfield Middlegate Village' ,`TaxAmount` = '4769' ,`TaxRate` = '2.3216' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779152' WHERE `Matrix_Unique_ID` = '213163040' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T21:44:30.640' ,`MLSNumber` = '63986050' ,`ListAgentFullName` = 'MaryAnne McFall' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = 'Barbara Chandler' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.071546' ,`Longitude` = '-95.566424' ,`PhotoCount` = '43' ,`PostalCode` = '77375' ,`RoomCount` = '10' ,`ListPrice` = '399000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Chaddington' ,`StreetNumber` = '9514' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2483' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make your appointment today to see this stunning one story Gehan Classic Series home in Inverness Estates! Cul-de-sac street. This home has been well loved and boasts many upgrades! Tankless water heater, Stone fireplace, exterior landscape lighting, whole house generator, dehumidifier & water filtration system, high ceilings, crown moulding & 8\' doors throughout the home, wood and tile flooring (only carpet in primary closet), gutters surround the entire house, kitchen appliances have been upgraded (microwave/convection oven, regular/convection oven, 5 burner stovetop, dishwasher, garbage disposal), Ecobee thermostat and room sensors, be sure to note the Gas firepit in backyard for fun gatherings around the fire! These are just a few of the upgrades, make your appointment now to see all it has to offer!Zoned to Klein ISD and easy access to 99, Exxon complex, The Woodlands,Bush airport, and the quaint downtown of Tomball! Walkthrough video can be viewed by clicking on movie reel icon' ,`Acres` = '0.1865' ,`Area` = '14' ,`BuilderName` = 'Gehan' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 2 INVERNESS ESTATES SEC 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MAHAFFEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Inverness Estates Sec 7' ,`TaxAmount` = '8876' ,`TaxRate` = '3.0565' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779152' WHERE `Matrix_Unique_ID` = '213178452' --> 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','213179051','1664779152','213179051','2022-10-02T20:31:24.830','10150208','Alicia Flores','Sierra Vista Realty LLC','','','29.687265','-95.230412','28','77502','4','222999.00','Active','Locust','1603','Street','Pasadena','2','0','4','1209','Single-Family','Come gather around this gorgeous newly remodeled home just minutes away from SH-225! This beauty has been completely updated with brand-new plumbing, HVAC, and electric work. A completely new bathroom was made turning this home into a 4 Bed/2 Bath. An open living room meets with the kitchen area where appliances have been installed accompanied by up-to-date cabinetry and granite counter tops. Foundation has been fully repaired. Roof has been entirely replaced. The backyard is so roomy, perfect for outdoor gatherings and reunions. No HOA! This one won\'t last, schedule your private tour now!','0.1653','6','','','','','Sellers Disclosure','','','','Pasadena','Central Electric','0','LT 10 BLK 16 SOUTHMORE PLAZA SEC 7','Subdivision Lot','7200','Appraisal District','','','0','','0','','0','','','','','Composition','41 - Pasadena','WILLIAMS ELEMENTARY SCHOOL (PASADENA)','PASADENA HIGH SCHOOL','QUEENS INTERMEDIATE SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','1','Other Style','Southmore Plaza Sec 07','2112','2.6514','Public Sewer,Public Water','1955','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:47:28.540' ,`MLSNumber` = '32933758' ,`ListAgentFullName` = 'Phyllis Clark' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Devin Duoto' ,`SellingOfficeName` = 'Texas Local Realty, LLC' ,`Latitude` = '29.911730' ,`Longitude` = '-95.643667' ,`PhotoCount` = '44' ,`PostalCode` = '77095' ,`RoomCount` = '16' ,`ListPrice` = '439900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sweetrose Place' ,`StreetNumber` = '15718' ,`StreetSuffix` = 'Place' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3381' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Agent is related to Sellers\r\nPrimary Bath remodel in 2018 \r\nGrout less shower walls, enlarged and added frameless shower enclosure, luxury vinyl flooring, new toilet, new bathtub and plumbing fixtures, ew shower pan and plumbing, onyx countertops.\r\n8 Nest smoke alarms added 2017.\r\nCustom drapes in family run will stay. Primary carpet replaced 2019, new high end front door installed in 2018.\r\nCrown molding throughout home added.\r\nNew roof 2020, outdoor patio added, kitchen remodel 2020 and all new Kitchen Aid appliances. Refrigerator excluded. Items on the back porch are excluded.' ,`Acres` = '0.206' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 4 ABERDEEN TRAILS SEC 4' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8973' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '589' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FIEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Aberdeen Trails Sec 04' ,`TaxAmount` = '7872' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779152' WHERE `Matrix_Unique_ID` = '213182424' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T20:16:31.070' ,`MLSNumber` = '50837896' ,`ListAgentFullName` = 'John Evans' ,`ListOfficeName` = 'J. R. Evans and Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531578' ,`Longitude` = '-95.162675' ,`PhotoCount` = '24' ,`PostalCode` = '77546' ,`RoomCount` = '4' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Forge Stone' ,`StreetNumber` = '2531' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2278' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming home is located on a Cul-De-Sac in the heart of Friendswood! This updated home features tile flooring throughout, neutral paint, and fantastic layout. Backyard has a covered patio & outdoor kitchen that is perfect for entertaining!' ,`Acres` = '0.1936' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 8B & 9A BLK 2 HERITAGE PARK SEC 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8435' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '167' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LANDOLT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'WESTBROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Heritage Park Sec 06' ,`TaxAmount` = '4803' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664779152' WHERE `Matrix_Unique_ID` = '213201844' --> 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','213209256','1664779153','213209256','2022-10-02T20:34:50.950','69544047','Becky Vance','Sky Real Estate Professionals','','','29.842331','-95.713815','31','77449','10','309900.00','Active','Rumbling Canyon','4702','Court','Katy','2','1','5','2602','Single-Family','Welcome Home! This amazing & spacious home has 4 bedrooms upstairs w/another bedroom downstairs that can double as an office. Tons of beautiful upgrades to include 20 x 20 ceramic tile throughout the home. The kitchen has gorgeous tall cabinets, stainless steel refrigerator, dishwasher, stove, built in microwave and granite countertops with a walk-in pantry. Highly efficient solar screens on all windows. There are ceiling fans in all the rooms. The luxurious primary suite is complete with high ceilings, a huge walk-in closet, custom made shower with built in bench. Backyard has high privacy fence that is great for entertaining your family and friends. Convenient location with easy access to I-10 & SH 99. Lots of local shopping. You are within walking distance to the community pool, park, elementary and middle schools. Awesome neighborhood with lots of room to raise a young family. The only thing missing is YOU!','0.1223','25','','','Washer Connections','','Sellers Disclosure','1','','','Bear Creek South','Central Electric','1','LT 18 BLK 2 WINDSTONE COLONY SEC 6','Corner','5326','Appraisal District','','250','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','SHERIDAN ELEMENTARY SCHOOL','CYPRESS LAKES HIGH SCHOOL','THORNTON MIDDLE SCHOOL (CY-FAIR)','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Windstone Colony Sec 6','6403','2.781','Public Sewer,Public Water','2004','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','213225241','1664779153','213225241','2022-10-02T21:49:44.863','28260812','Ashley Van den Heuvel','JLA Realty','','','30.040288','-95.470571','35','77388','13','359900.00','Active','Fir Forest','3647','Drive','Spring','2','1','4','2422','Single-Family','Beautiful two story home in the quaint neighborhood of Cypresswood. This 4 bedroom, 2.5 bath provides for the perfect place to call home. The living room is spacious allowing for plenty of room for entertaining guests. It has large picture windows that showcases the beauty of the huge backyard. This backyard is big enough to put a pool or hot tub and make it into your own oasis! The kitchen opens up to the breakfast area and a cute coffee bar. Spacious bedrooms and a home office allow for ample room to work from home. With a large primary bedroom and his/her walk in closets, you are walking into the perfect retreat. The upstairs features a bonus room that you can make into your own game room/media room! LOTS OF UPGRADES AND UPDATES DONE. PLEASE SEE UPGRADE LIST!','0.1848','13','','','','','Mud,Sellers Disclosure','','','1','Spring/Klein','Central Gas','1','LT 2 BLK 36 CYPRESSWOOD SEC 8','Subdivision Lot','8050','Appraisal District','','535','0','','1','','0','','','Electric Cooktop','','Tile','32 - Klein','HAUDE ELEMENTARY SCHOOL','KLEIN COLLINS HIGH SCHOOL','STRACK INTERMEDIATE SCHOOL','Appointment Required,Controlled Access','Appraisal District','1.5','Traditional','Cypresswood Sec 08','5194','2.5715','Water District','1981','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213225652','1664779153','213225652','2022-10-02T21:05:10.077','30704537','Paolinnie Brown','Realty Executives','','','29.798971','-95.137526','16','77530','8','325000.00','Active','Bonita Grulla','15425','Way','Houston','2','1','4','2576','Single-Family','Beautiful home located in the Rancho Verde subdivision. Don\'t miss out on this well kept 2 story beauty. Wood tile downstairs and carpet upstairs. Water filtration system installed. Window screens installed on all windows of the home. Security cameras installed on front and back of home along with a Ring doorbell.','0.1157','2','','','Electric Dryer Connections','','No Disclosures','','','','North Channel','Central Electric','1','LT 32 BLK 5 RANCHO VERDE SEC 7','Subdivision Lot','5040','Appraisal District','','500','0','','2','Gas Oven','0','','','Gas Range','','Composition','8 - Channelview','HAMBLEN ELEMENTARY SCHOOL','CHANNELVIEW HIGH SCHOOL','JOHNSON JUNIOR HIGH','Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox','Appraisal District','2','Traditional','Rancho Verde Sec 7','6610','2.618','Public Sewer,Public Water','2017','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213226874','1664779153','213226874','2022-10-02T21:57:11.910','46176437','Ashauna Lindo','CR Elite Realty','','','29.631826','-95.444607','12','77045','3','124000.00','Active','Trail Lake','4411','Drive','Houston','1','0','3','1022','Single-Family','Don\'t miss this great opportunity to make this home yours! Perfect for investors! A traditional-style home located in the heart of Pamela Heights!','0.1569','18','','','','','Sellers Disclosure','','','','Five Corners','Central Electric','0','LT 5 BLK 6 PAMELA HEIGHTS SEC 1','Subdivision Lot','6834','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','HOBBY ELEMENTARY SCHOOL','MADISON HIGH SCHOOL (HOUSTON)','LAWSON MIDDLE SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Pamela Heights Sec 01','2478','2.3307','Water District','1961','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','213227229','1664779153','213227229','2022-10-02T20:27:02.830','29881417','Karen Hoffpauir','eXp Realty, LLC','','','29.965100','-94.011088','30','77627','7','335000.00','Active','Mimosa','1007','Drive','Nederland','2','0','4','2262','Single-Family','This house is a must see! So gorgeous and the perfect location! Beautiful home located in Helena Park Edition of Nederland. This is a wonderful neigborhood close to schools and shopping. This lovely 4 bedroom 2 bath home has been completely remodeled.The roof and garage door has been replaced and are windstorm certified. All windows have been replaced and are windstorm certified as well. New Ac/ Gas heating. All new sheetrock and insulation, all new interior and exterior doors , trim, all new cabinets, quartz countertops. The home is accented with matte black handles and fixtures. Primary bath has a free standing tub and shower, and hall bath has a shower/tub combo, with a deep soaking bath tub. The home has so much natural light from all of the windows and the beautiful patio doors.There is so much storage with all of the closets. Vinyl plank flooring was installed throughout. The home is owned by the listing agent, Karen Hoffpauir, with EXP Realty-409-960-1234.','0.2235','51','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','','Central Gas','0','HELENA PARK LT 4 BLK 2','Other','9734','Appraisal District','','','0','','2','','0','','','','','Composition','152 - Nederland','HELENA PARK ELEMENTARY SCHOOL','NEDERLAND HIGH SCHOOL','WILSON MIDDLE SCHOOL (NEDERLAND)','Accompany,Appointment Required,Leave Business Card,Lockbox Back','Appraisal District','1','Contemporary/Modern','Helena Park 1','4913','2.4292','Public Sewer,Public Water','1968','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','213227408','1664779153','213227408','2022-10-02T20:37:54.030','75559900','Lonnie Wade','Invest Houston Realty','','','29.623354','-95.436399','25','77045','6','170000.00','Active','Heatherbloom','3922','Drive','Houston','1','1','3','1507','Single-Family','THIS IS A 3 BEDROOM HOUSE WITH TWO EXTRA ROOMS THAT COULD BE BEDROOMS. TENANT HAS JUST MOVED OUT SO NO ELECTRICITY, NO WATER & HAS NOT BEEN CLEANED.','0.1326','18','','','','','Sellers Disclosure','','','','Five Corners','Central Electric','0','W 5 FT OF LT 15 & E 50 FT OF LT 16 BLK 7 SOUTHGLEN SEC 1','Subdivision Lot','5775','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)','MADISON HIGH SCHOOL (HOUSTON)','LAWSON MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Contemporary/Modern','Southglen Sec 01','2645','2.3307','Public Sewer,Public Water','1959','Appraisal District'); --> New record created successfully