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-11-20T21:53:28.450' ,`MLSNumber` = '41336425' ,`ListAgentFullName` = 'Evelyn Guinn' ,`ListOfficeName` = 'Premier Relocation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.050251' ,`Longitude` = '-95.365536' ,`PhotoCount` = '16' ,`PostalCode` = '77373' ,`RoomCount` = '4' ,`ListPrice` = '197900.00' ,`Status` = 'Active' ,`StreetName` = 'Enchantedgate' ,`StreetNumber` = '4538' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BACK ON MARKET. NO INSPECTIONS WERE DONE. BUYER COULDN\'T GET LOAN. Step into this Birnam Wood beauty and feel right at home! Great floor plan with 4 bedrooms and 2 bathrooms. The primary bedroom is large with lots of closets and the secondary bedrooms are very good sizes. You will enjoy the wood burning fireplace with a nice hearth. The tall ceiling in the living room gives it a spacious feel. Nice sized kitchen and the stainless steel refrigerator stays. Check out the big backyard. Schedule your showing today. We think you will love it. Room sizes are approximate. Do you own due diligence if necessary. Perfect family home or rental property.' ,`Acres` = '0.1597' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 BIRNAM WOOD SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6955' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '415' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MILDRED JENKINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Birnam Wood Sec 04' ,`TaxAmount` = '3243' ,`TaxRate` = '2.7118' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669056987' WHERE `Matrix_Unique_ID` = '199790290' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T21:21:56.863' ,`MLSNumber` = '82493782' ,`ListAgentFullName` = 'Taryn Ashley Diaz' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.844274' ,`Longitude` = '-95.428708' ,`PhotoCount` = '6' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Wheatley' ,`StreetNumber` = '5418E' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1825' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HOME IS READY FOR IMMEDIATE MOVE-IN. Sales Center at corner of Wheatley and W Tidwell open Thursday-Sunday and by appointment. Welcome home to Commons at Ella Forest where you can finally check off everything on your Wishlist! With (91) well-designed Single Family Homes come in a selection of three-floor plan designs offering 2 or 3 Story options & First Floor Living (*per plan). The generous sized ‘A’ floor plan features Second floor living, a free-flowing cooking-dining-living space, attached 2 car garage, first floor guest bedroom, third floor primary w/walk-in closet, third floor central laundry room, second & third bedrooms with ensuite bathroom. This exciting new gated community will provide walking paths for enjoying the outdoors along with picturesque fountains and landscaping. Located just 15 minutes from Houston’s Galleria or Downtown and just 3 blocks north of Upscale Oak Forest.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Shepherd Park Plaza Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 62 BLK 1 COMMONS AT ELLA' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1559' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Commons at Ella Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056987' WHERE `Matrix_Unique_ID` = '201918019' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T21:48:55.457' ,`MLSNumber` = '70485771' ,`ListAgentFullName` = 'Huyen Nguyen' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.827755' ,`Longitude` = '-95.524893' ,`PhotoCount` = '46' ,`PostalCode` = '77080' ,`RoomCount` = '9' ,`ListPrice` = '289999.00' ,`Status` = 'Active' ,`StreetName` = 'Railton' ,`StreetNumber` = '9419' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy one-story house in a quiet neighborhood in Spring Branch. 4 bedrooms and 2 FULL BATHS! Huge den/living room with tile floor throughout the house, NO Carpet in the house makes the home allergy friendly! New air conditioner in 2020! Clothes WASHER, DRYER, REFRIGERATOR AND COUNTER MICROWAVE INCLUDED! Huge extra room can be an enclosed play area, work room, or fitness center! Minutes away and easy access to shopping centers, grocery stores, US Highway 290, W Sam Houston Tollway, 15 minutes to Memorial Herman Hospital and Memorial City Mall. NO HOA zoned to Spring Branch ISD! Move-in ready.' ,`Acres` = '0.1742' ,`Area` = '24' ,`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` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 4 SPRING BRANCH SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7590' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUFFALO CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'NORTHBROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Branch Sec 01' ,`TaxAmount` = '5606' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056987' WHERE `Matrix_Unique_ID` = '211185256' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T22:30:55.813' ,`MLSNumber` = '36149615' ,`ListAgentFullName` = 'William Jenkins' ,`ListOfficeName` = 'The Hatmaker Group' ,`SellingAgentFullName` = 'Ashlee Hutson' ,`SellingOfficeName` = 'Keller Williams, LLC' ,`Latitude` = '29.285253' ,`Longitude` = '-94.823824' ,`PhotoCount` = '32' ,`PostalCode` = '77551' ,`RoomCount` = '6' ,`ListPrice` = '309000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Avenue O' ,`StreetNumber` = '5216' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1468' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully restored and renovated 1939 cottage. Natural light abounds throughout the house with tons of windows and glass storm doors. 3 bedrooms, with no shared walls, provide lots of space and privacy for family and friends, or for home office or craft rooms. Original hardwoods throughout most of the house keep with the historic charm while updated kitchen and bathrooms keep up with the times! The kitchen features IKEA cabinetry with soft close doors and drawers, all with a 25 year warranty. There is plenty of off street parking with a drive through drive way that goes from Ave O to the alley. Also, there is plenty of room out back for a garage or carport. The front in beautifully landscaped with a mature plumeria in bloom!' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOTS 19 & 20 BLK 77 DENVER RESURVEY' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Denver Resurvey' ,`TaxAmount` = '2893' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1939' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669056987' WHERE `Matrix_Unique_ID` = '211316483' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T21:20:41.470' ,`MLSNumber` = '28525336' ,`ListAgentFullName` = 'Rachel Solbach-Witt' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.844499' ,`Longitude` = '-95.428707' ,`PhotoCount` = '45' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Wheatley' ,`StreetNumber` = '5422C' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Sales Center at corner of Tidwell and Wheatley open Thursday-Sunday and by appointment*** Welcome home to Commons at Ella Forest where you can finally check off everything on your Wishlist! With (91) well-designed Single Family Homes come in a selection of three-floor plan designs offering 2 or 3 Story options & First Floor Living. The generous sized ‘B’ floor plan features First floor living w/half bath for guest, a free-flowing cooking-dining-living space, attached 2 car garage, Second floor w/2 guest bedrooms with jack & jill bathroom, primary w/walk-in closet, dual sinks, separate soaking tub & shower. This exciting new gated community will provide walking paths for enjoying the outdoors along with picturesque fountains and landscaping. Located just 15 minutes from Houston’s Galleria or Downtown and just 3 blocks north of Upscale Oak Forest' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Shepherd Park Plaza Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 58 BLK 1 COMMONS AT ELLA' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '2042' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Commons at Ella Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056987' WHERE `Matrix_Unique_ID` = '211969511' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T21:20:56.710' ,`MLSNumber` = '3574821' ,`ListAgentFullName` = 'Rachel Solbach-Witt' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.844274' ,`Longitude` = '-95.428708' ,`PhotoCount` = '50' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Wheatley' ,`StreetNumber` = '5406C' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1825' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Sales Center at corner of Wheatley and W Tidwell open Thursday-Sunday and by appointment*. Welcome home to Commons at Ella Forest where you can finally check off everything on your Wishlist! With (91) well-designed Single Family Homes come in a selection of three-floor plan designs offering 2 or 3 Story options & First Floor Living. The generous sized ‘A’ floor plan features Second floor living, a free-flowing cooking-dining-living space, attached 2 car garage, first floor guest bedroom, third floor primary w/walk-in closet, third floor central laundry room, second & third bedrooms with ensuite bathroom. This exciting new gated community will provide walking paths for enjoying the outdoors along with picturesque fountain and landscaping. Located just 15 minutes from Houston’s Galleria or Downtown and just 3 blocks north of Upscale Oak Forest.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Shepherd Park Plaza Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 82 BLK 1 COMMONS AT ELLA' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1515' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Commons at Ella Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056988' WHERE `Matrix_Unique_ID` = '212455827' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T21:21:38.847' ,`MLSNumber` = '78550249' ,`ListAgentFullName` = 'Taryn Ashley Diaz' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.844274' ,`Longitude` = '-95.428708' ,`PhotoCount` = '50' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'Wheatley' ,`StreetNumber` = '5406F' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1825' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sales Center at corner of Wheatley and W Tidwell open Thursday-Sunday and by appointment. Welcome home to Commons at Ella Forest where you can finally check off everything on your Wishlist! With (91) well-designed Single Family Homes come in a selection of three-floor plan designs offering 2 or 3 Story options & First Floor Living. The generous sized ‘A’ floor plan features Second floor living, a free-flowing cooking-dining-living space, attached 2 car garage, first floor guest bedroom, third floor primary w/walk-in closet, third floor central laundry room, second & third bedrooms with ensuite bathroom. This exciting new gated community will provide walking paths for enjoying the outdoors along with picturesque fountain and landscaping. Located just 15 minutes from Houston’s Galleria or Downtown and just 3 blocks north of Upscale Oak Forest.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Shepherd Park Plaza Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 79 BLK 1 COMMONS AT ELLA' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2377' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Commons at Ella Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056988' WHERE `Matrix_Unique_ID` = '212459274' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T22:31:34.297' ,`MLSNumber` = '79590480' ,`ListAgentFullName` = 'Dixie Reeves' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = 'Antonio Orozco' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '30.132969' ,`Longitude` = '-95.562103' ,`PhotoCount` = '26' ,`PostalCode` = '77375' ,`RoomCount` = '7' ,`ListPrice` = '389900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Marmite' ,`StreetNumber` = '25603' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2218' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Searching for a beautiful home that has been completely remodeled, move-in ready & is located in the highly acclaimed Tomball School District? Look no further, this home is it! The kitchen has been updated with new stainless steel LG appliances, upgraded backsplash and new quartz countertops. Additional upgrades include fresh paint with a modern color palette throughout, new flooring throughout, plus updated light fixtures. But that\'s not all...both bathrooms have been updated as well! The primary en-suite features a semi-frameless glass shower with separate bathtub, quartz countertop, dual sinks and updated light fixtures. This home also features PEX plumbing, a new fence, plus an in-ground sprinkler system. A great bonus to this home is the location. Beautiful Burroughs Park is 1 mile away. Downtown Tomball with all of its great shopping & dining is just 6 miles away & The Woodlands is within a few miles. Don\'t miss out on this amazing home! It is truly the gem of the subdivision!' ,`Acres` = '0.1263' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 2 SADDLEBROOK VILLAGE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Saddlebrook Village Sec 03' ,`TaxAmount` = '6470' ,`TaxRate` = '2.784' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056988' WHERE `Matrix_Unique_ID` = '212607280' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T21:09:53.963' ,`MLSNumber` = '61558782' ,`ListAgentFullName` = 'Sarah Conway' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Sarah Conway' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.425743' ,`Longitude` = '-95.620436' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '9' ,`ListPrice` = '479900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Carmel' ,`StreetNumber` = '22' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2911' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular home on cul-de-sac lot in the desirable gated Lake Conroe community of Bentwater. Nestled on the stunning golf course street, this 3-BR, 2.5-Bath property boasts generous room sizes, plantation shutters, living area with tray ceiling & built-ins, an elegant formal dining room, and a spacious study overlooking the courtyard. The island kitchen includes expansive countertops & loads of storage; open the breakfast room with far-reaching views. Owner’s suite w/ generous walk-in closet, dual vanities, tub, & separate shower. 2 private secondary BRs share a pass-through bath. Oversized screened porch w/ picturesque golf course views of Weiskopf #8 and pond! NEW ROOF! Fenced yard, bug spray system, & mature landscaping. Enjoy life like you\'re on a vacation with access to the country club, THREE 18-hole championship golf courses, the yacht club, sports club, pickle ball, dog park, and 24 hr manned gate!!! Sought after MISD!' ,`Acres` = '0.184' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 68, BLOCK 1, LOT 19' ,`LotDesciption` = 'Cleared,In Golf Course Community,On Golf Course,Patio Lot,Subdivision Lot,Water View' ,`LotSize` = '8017' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1146' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '6827' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056988' WHERE `Matrix_Unique_ID` = '212709978' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T22:07:55.847' ,`MLSNumber` = '25509175' ,`ListAgentFullName` = 'Holley Madden' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Keeyan Sabz' ,`SellingOfficeName` = 'Intero Real Estate Services' ,`Latitude` = '29.792834' ,`Longitude` = '-95.484268' ,`PhotoCount` = '24' ,`PostalCode` = '77055' ,`RoomCount` = '8' ,`ListPrice` = '695000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bobbitt' ,`StreetNumber` = '7871' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3420' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom home in gated community with 1st floor living & a French inspired design. Gleaming hardwood floors, Plantation shutters, crown molding, and a highly functional floorplan which includes an impressive entry way, office behind French doors, spacious living, dining, & island kitchen with pantry & breakfast bar. This large street-facing lot provides a fully fenced outdoor space with recent landscaping. Kitchen offers natural tone granite counters, Bosch SS appliances, & custom Brookhaven cabinets. Primary suite on the second floor is incredibly spacious with room for many furniture arrangements. Large bath provides dual vanities, separate tub, large walk in shower, & oversized walk-in closet. 2 additional guest bedrooms on the 2nd floor with walk-in closets & Hollywood bath. 3rd floor bedroom features private bath and walk-in closet. This room could also function as a game room. Zoned to SBISD schools. Energy efficient geothermal heating and cooling systems * per seller.' ,`Acres` = '0.0676' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 BOBBITT HEIGHTS R/P AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2943' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HUNTERS CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Bobbitt Heights Rep 01 Amd Pla' ,`TaxAmount` = '15956' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056989' WHERE `Matrix_Unique_ID` = '212844091' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T21:06:24.883' ,`MLSNumber` = '14990342' ,`ListAgentFullName` = 'Cuong Le' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = 'Jason Russell' ,`SellingOfficeName` = 'Fathom Realty' ,`Latitude` = '29.176762' ,`Longitude` = '-94.982684' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '13' ,`ListPrice` = '1825000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Termini San Luis Pass' ,`StreetNumber` = '17225' ,`StreetSuffix` = 'Road' ,`City` = 'Galveston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2954' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'True beachfront home on 1.5 acres with 940 sf covered decking offering beautiful unobstructed Gulf views. High end finishes and furnishings throughout. Open floor plan with spacious chef\'s kitchen featuring large island, double sinks, wine fridge, gas range & large walk-in pantry. Tranquil views of the gulf through a wall of windows. Bay views from the north side of the home. All bedrooms include en-suite bathrooms. Utility room w/washer and dryer included. Tesla charger, full service elevator to all 3 levels, fully fenced, mosquito system, floor to ceiling kitchen cabinetry, quartz counters, shiplap walls, Coretec luxury vinyl planks, tile floors, wired for security/cameras and speakers inside and out, recessed LED lighting, smart Nest thermostat, vinyl low-e impact windows & doors, high efficiency HVAC system, and on demand tankless water heater. Private dune walkway that leads to the beach. No HOA and Vacation Rentals Allowed. This exquisite beachfront home conveys fully furnished!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 2 ACQUISITIONS BEACH (2018) ABST 121' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '65297' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Acquisitions Beach' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056989' WHERE `Matrix_Unique_ID` = '213529545' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T21:35:54.950' ,`MLSNumber` = '44891527' ,`ListAgentFullName` = 'Richard Elkowitz' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.622448' ,`Longitude` = '-95.773766' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '10' ,`ListPrice` = '590000.00' ,`Status` = 'Active' ,`StreetName` = 'Shadow' ,`StreetNumber` = '2015' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2712' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Living in the country, but close to everything. Absolutely stunning updated interior design situated on 1.859 unrestricted acres. Oh. The home has two primary bedrooms with gorgeous private bathrooms. First class stuff. The interior has been totally updated down to the framing studs. Flooring, kitchen, bathrooms, walls, roof, underground plumbing; interior plumbing updates; cement board siding and more. The beauty will knock your socks off. The home was just measured by an appraiser at 2,712 square feet. NO HOA fees. NO MUD taxes. Gas lines have been installed in the attic for future use if desired. Want to build towards the back of the property someday? Electrical lines already in place for future construction. Water softer system. No carpet. Mostly ceramic Italian tile. Slow close drawers and cabinets. Quartz counters. Home has not been lived in since updated. Extra room is off the primary bedroom. Makes a great study, or exercise room.' ,`Acres` = '1.86' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0046 KNIGHT AND WHITE, TRACT 119, ACRES 1.86, LOT 5 PECAN S' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '81022' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Knight & White' ,`TaxAmount` = '5461' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056989' WHERE `Matrix_Unique_ID` = '214011314' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T21:35:21.223' ,`MLSNumber` = '61094593' ,`ListAgentFullName` = 'Patricia Woldtvedt' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.475257' ,`Longitude` = '-95.167299' ,`PhotoCount` = '22' ,`PostalCode` = '77573' ,`RoomCount` = '6' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Sugar Trail' ,`StreetNumber` = '616' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home with eye catching tray ceilings in the foyer as you enter. Fabulous kitchen overlooking the spacious living room with a large breakfast bar area with seating area, generous counter/prep space and tons of cabinet storage. The island with cabinets is centered in the kitchen with a fabulous Skylight above bringing in beautiful natural light throughout. Offers a dining room boasting with your very own Butlers Pantry with glass doors. \r\n3 bedroom 2.5 bath with a study/office space/flex room or 4th bedroom. Your own oasis awaits as you enter the primary bedroom with tray ceilings and luxurious ensuite. Bedroom overlooks a spacious backyard with no back neighbors, garden beds awaiting new owners to create their own masterpiece, a 8x10 shed for tools and a covered patio for relaxing or entertaining. 3 car garage for vehicles, recreational toys or additional space. Local community ponds, recreation center & pool for your enjoyment. Call now to schedule your showing!!' ,`Acres` = '0.1884' ,`Area` = '33' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 42 BLK 1 WESTWOOD SUB SEC 7 (2018) ABST 614' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8209' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Sub' ,`TaxAmount` = '10567' ,`TaxRate` = '3.0697' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056989' WHERE `Matrix_Unique_ID` = '214017035' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T21:59:00.830' ,`MLSNumber` = '13196352' ,`ListAgentFullName` = 'Jackie Murray' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.688741' ,`Longitude` = '-95.438337' ,`PhotoCount` = '49' ,`PostalCode` = '77025' ,`RoomCount` = '7' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Linkview' ,`StreetNumber` = '3814' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3089' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remarkable home features premium selections that are showcased in this beautifully appointed home.Exterior w/limestone rock & front porch on a well positioned double lot.Living room w/fireplace,recessed lighting & crown molding.Dining room open to the living room.Kitchen has been stylishly updated w/quartz counters,SS appliances,built in pantry,gas range & farm house sink.Charming second living space off of kitchen w/shiplap & wood beam ceiling.Oversized primary retreat w/gleaming hardwood floors!Primary bath w/walk-in shower,double sinks,separate vanity & huge closet.Generous size secondary bedrooms w/updated guest bath that features tub/shower.Covered patio overlooking the sparkling pool.Even with a pool there is plenty of yard on this oversized lot!2 car attached garage features bonus cabana! Great for additional storage. Large storage shed in backyard.Updates:foundation repaired w/lifetime warranty,new windows,fresh paint,new front porch,refinished hardwood floors & much more!' ,`Acres` = '0.3581' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Knollwood/Woodside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 29 & TRS 28A & 30A BLK 2 LINKWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LONGFELLOW ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Linkwood' ,`TaxAmount` = '16291' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056990' WHERE `Matrix_Unique_ID` = '214028693' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T22:43:27.040' ,`MLSNumber` = '80263206' ,`ListAgentFullName` = 'Jasmin Clopton' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.742693' ,`Longitude` = '-95.550507' ,`PhotoCount` = '36' ,`PostalCode` = '77042' ,`RoomCount` = '7' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Lake' ,`StreetNumber` = '10038' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3327' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully renovated home located in warm and friendly BRIARGROVE PARK. Very spacious home with five bedrooms and fantastic pool. Home boasts many upgrades. Porcelain wood look tile throughout common areas perfect for wet floors after those fun pool activities. Completely updated kitchen with quartz countertops, soft close cabinets and high end appliances. Custom cabinets with built in bench for morning breakfast gatherings. Grand primary suite with extra large shower. Other upgrades includes new exterior siding 2022, new roof shingles 2022, double pane high end windows, custom shutters, Pex plumbing 2022, Trane HVAC system 2022, sprinkler system, mosquito misting system and much more. Ask you agent for a full list of all updates.' ,`Acres` = '0.1937' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 230 BLK 8 BRIARGROVE PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8439' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Briargrove Park Sec 01' ,`TaxAmount` = '12353' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056990' WHERE `Matrix_Unique_ID` = '214094176' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T21:52:00.983' ,`MLSNumber` = '4809696' ,`ListAgentFullName` = 'Ivan Martinez' ,`ListOfficeName` = 'Vylla Home' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.974740' ,`Longitude` = '-95.524481' ,`PhotoCount` = '15' ,`PostalCode` = '77069' ,`RoomCount` = '10' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Mission Valley' ,`StreetNumber` = '13002' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Calling all investors INVESTMENT OPPORTUNITY in sought after Champions Gulf community. Zoned to acclaimed Cypress Fairbanks ISD. This home features 3 Beds/3.5 Baths. Will need a complete rehab to reach its full potential. Buyers and buyers\' agent to verify any and all info.' ,`Acres` = '0.36' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Real Estate Owned' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 27 BLK 1 CHAMPIONS SOUTH' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,On Golf Course' ,`LotSize` = '15744' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Champions South' ,`TaxAmount` = '10275' ,`TaxRate` = '2.4906' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056990' WHERE `Matrix_Unique_ID` = '214330997' --> 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','214396399','1669056990','214396399','2022-11-20T22:50:55.700','17480224','Cindy Bell','HomeSmart','Joyce Paul','Stride Real Estate, LLC','29.552331','-95.513530','24','77459','8','318000.00','Option Pending','Argos','1902','Drive','Missouri City','2','0','4','1828','Single-Family','Corner Lot! One story 4 bedroom, 2 bath 2 car attached garage on large lot. Brick home with large family room that opens to kitchen with island, lots of counter space and cabinets. Gas cooking and refrigerator included. Breakfast room with window seats looks out to great view of back yard. Primary bedroom is light and bright with double vanity in primary bath. Separate shower and large walk in closet. Three bedrooms share the secondary bathroom with tub/shower combo. Utility room in house includes washer and dryer. Alarm system in utility. Carpet in all rooms except tile in bathrooms, kitchen and breakfast room. Covered patio and nice size back yard for entertaining fence freshly stained. Close to shopping, churches, schools and several major hwys.','0.1694','38','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Missouri City Area','Central Gas','1','OLYMPIA ESTATES SEC 8, BLOCK 3, LOT 24','Corner','7377','Appraisal District','','360','0','','2','Freestanding Oven,Gas Oven','0','','','','','Composition','19 - Fort Bend','PALMER ELEMENTARY SCHOOL (FORT BEND)','HIGHTOWER HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern','Olympia Estates Sec 8','6684','3.13','Water District','2016','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214427966','1669056990','214427966','2022-11-20T21:56:19.903','97199168','Hai Huynh','Keller Williams Signature','','','29.613146','-95.258107','9','77075','3','270000.00','Active','Summerset Meadow','8927','Court','Houston','2','0','3','1681','Single-Family','Beautiful 3 bedrooms, 2 bathrooms, 1-story home in highly desired Clearwood Crossing subdivision. Open floor plan, Pergo tile, wood laminate floors in living area, computer drops in all rooms, PEX manifold water system and custom built bookshelf! Only 2 blocks to the park with a jogging trail. Pecan tree in front and orange and lemon tree in the backyard. Easy access to Beltway 8, I-45 and 288 with short distance commute to medical center. Please schedule your showing today!','0.1136','3','','','','','Sellers Disclosure','1','','','Southbelt/Ellington','Central Gas','1','LT 110 BLK 1 CLEARWOOD CROSSING SEC 4','Subdivision Lot','4950','Appraisal District','','350','0','','2','','0','','','','','Composition','41 - Pasadena','BUSH ELEMENTARY SCHOOL','DOBIE HIGH SCHOOL','BEVERLYHILLS INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Clearwood Xing Sec 4','6080','3.1563','Public Sewer,Public Water,Water District','2009','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T22:02:50.813' ,`MLSNumber` = '38027092' ,`ListAgentFullName` = 'Diana Sprott' ,`ListOfficeName` = 'Keller Williams Advntge Realty' ,`SellingAgentFullName` = 'Sherri Barrett' ,`SellingOfficeName` = 'Emblem Properties' ,`Latitude` = '30.659487' ,`Longitude` = '-95.527842' ,`PhotoCount` = '50' ,`PostalCode` = '77340' ,`RoomCount` = '9' ,`ListPrice` = '335000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cherry Hills' ,`StreetNumber` = '803' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2023' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'When you purchase in Elkins Lake you are purchasing more than just a home, you are purchasing a lifestyle! Beautifully maintained 3 bedroom/2 bath, split bedroom plan with study/office is move-in ready. Family room and kitchen combination is perfect for the cook who does not want to be separated from family and guests. The large backyard is perfect for hosting family gatherings and the family pet. The home is located on an oversized lot in the recreational subdivision of Elkins Lake and comes with a roomy 10x16 \'Tuff\' shed, perfect for storing lawn care equipment, kayaks, fishing poles, and so much more. Elkins Lake has three 9-hole championship courses, 3 private lakes, 2 swimming pools, lighted tennis and pickleball courts, walking trails, and a clubhouse with dining facilities. All amenities are for the exclusive use of property owners and their guests.' ,`Acres` = '0.38' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ELKINS LAKE - SEC 1, BLOCK 9, LOT 22' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '16551' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '198' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elkins Lake' ,`TaxAmount` = '5309' ,`TaxRate` = '1.8868' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056990' WHERE `Matrix_Unique_ID` = '214445727' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T21:54:39.100' ,`MLSNumber` = '97789336' ,`ListAgentFullName` = 'Tracey Page' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812403' ,`Longitude` = '-95.394347' ,`PhotoCount` = '32' ,`PostalCode` = '77008' ,`RoomCount` = '4' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = '28th' ,`StreetNumber` = '405' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1026' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming bungalow in the heart of the Heights. House has beautiful hardwood floors, tons of natural light, spacious floor plan and beautiful French doors separate the living and dining area. Kitchen is equipped with granite countertops, glass front cabinetry and plenty of space. Adding to the charm of this house is a clawfoot bathtub. Exterior has beautiful trees, storage building and plenty of outdoor space. Close to all things Heights. Perfect first home, downsizing or investment property. Per Seller new dishwasher 2019, Water Heater approximately 2018 and HVAC 2021.Easy access to Downtown, Medical Center, Galleria and Energy Corridor. Call for you appointment today.' ,`Acres` = '0.0897' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 21 22 & TR 23 BLK 12 SUNSET HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4183' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Sunset Heights' ,`TaxAmount` = '7565' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1928' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056991' WHERE `Matrix_Unique_ID` = '214470600' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T21:49:34.330' ,`MLSNumber` = '3633003' ,`ListAgentFullName` = 'CamDung Le' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.862846' ,`Longitude` = '-95.795743' ,`PhotoCount` = '33' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Grey Lake Court' ,`StreetNumber` = '24310' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3137' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RARE BRAND-NEW JULY 2022 HistoryMaker Home 4-5bedroom 3 full bath 2 bedroom-down in exceptional cul-de-sac COMPLETELY UPGRADED in highly sought at KATY LAKES. Lush landscaping welcome you to the front door with large window. As you enter, you are greeted with a WOW staircase, BEAUTIFUL flooring, interior paint & open floorplan with BEAUTIFUL HIGH CEILING. You\'ll also have the effortless flow of the kitchen bar, breakfast & family room. $90k+ UPGRADED. Wall-length windows provide so much natural lighting. Family room features tall, vaulted HIGH CEILING. Kitchen features porcelain countertop & UPGRADED SS appliances. Second floor offers spacious 2secondary bedrooms & game room, OVERSIZED MEDIA ROOM with even more built-ins & additional storage 2.5 GARAGE. There\'s no better place to end your day than out at the serene backyard with HUGE patio. Let\'s not forget the sprinkler system. Easy access to Grand Parkway, i10, Downtown. ZONED KATY ISD! DON\'T MISS IT!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 4 KATY LAKES SEC 05' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7232' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056991' WHERE `Matrix_Unique_ID` = '214518010' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T21:15:02.557' ,`MLSNumber` = '54945970' ,`ListAgentFullName` = 'Darby Grimmett' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.201377' ,`Longitude` = '-94.945650' ,`PhotoCount` = '43' ,`PostalCode` = '77554' ,`RoomCount` = '9' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Oleander' ,`StreetNumber` = '4020' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful extensively remodeled & fully furnished BEACHSIDE home located in Palm Beach, conveniently located on Galveston’s “West End” between 12 Mile Rd and 13 Mile Rd. Incredible opportunity - perfect as an INCOME PRODUCING investment property (Sleeps 18 or more), family getaway or permanent residence. The main level features an incredible kitchen, complete with island and an abundance of seating, and is open to the family room. Four bedrooms (two master bedrooms) and three full baths + separate sitting areas can also be found as well on the main area - perfect for multiple families staying together. Guest quarters with full bathroom on the ground floor for additional family & friends (is NOT included in bed/bath count of main living area). Large decks, outdoor shower, covered outdoor living areas, and storage area (with everything you need to enjoy the beach)! This property truly has it all - renovated AND a quick walk to the beach, yet close to Galveston\'s popular island venues.' ,`Acres` = '0.1087' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR S 1/2 OF LOT 39 (39-1) BLK 2 PALM' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4736' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Palm Beach' ,`TaxAmount` = '7824' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056991' WHERE `Matrix_Unique_ID` = '214549757' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T21:35:21.067' ,`MLSNumber` = '86990038' ,`ListAgentFullName` = 'Jason Hooley' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = 'Eric Beeler' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.072252' ,`Longitude` = '-95.778810' ,`PhotoCount` = '19' ,`PostalCode` = '77447' ,`RoomCount` = '7' ,`ListPrice` = '319900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Penny Blume' ,`StreetNumber` = '20323' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2208' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming updates! The lovely community of Bauer Landing welcomes you to your two-story 4/2.5 home. The efficient floorplan complements your lifestyle and has lots of updates to enjoy! Primary suite is downstairs; three secondary bedrooms are up, all with walk-in closets. The modern kitchen features granite countertops and stainless appliances. Relax or play in the huge backyard - complete with fire pit and covered patio! New paint inside and out, new lighting and plumbing fixtures, new carpet, and NO HISTORY OF FLOODING! Superb access to Grand Parkway, excellent schools, and tons of amenities! Come and see today!' ,`Acres` = '0.2648' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 5 BAUER LANDING SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11535' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bauer Lndg Sec 1' ,`TaxAmount` = '6965' ,`TaxRate` = '2.8556' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056991' WHERE `Matrix_Unique_ID` = '214566690' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T22:16:29.413' ,`MLSNumber` = '18276719' ,`ListAgentFullName` = 'Natasha Norregaard' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.204876' ,`Longitude` = '-94.942225' ,`PhotoCount` = '10' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Pirates Beach' ,`StreetNumber` = '13930' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1390' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the highly desirable community of Pirates Beach. Situated on a quiet street, just a short stroll to the beach. No expense spared on this NEW CONSTRUCTION with an estimated completion of December 19, 2022. Home includes 3 bedrooms, 2 baths and an outdoor shower. Primary bedroom and bedroom 2 have 8 ft sliding glass doors that bring you out to the back balcony, perfect for watching the gorgeous island sunsets. \r\n\r\nHome includes: Impact rated Pella windows and 8ft sliding glass doors, triple panel sliding glass door entrance, Calacatta quartz countertops throughout, light grey cabinets throughout, top of the line SS appliances, floor to ceiling tile in the bathroom, solid glass shower, luxury vinyl plank flooring, EV Charging station and downstairs shower to wash off from the beach. Ceiling heights vary from 10-12 feet throughout!' ,`Acres` = '0.1451' ,`Area` = '33' ,`BuilderName` = 'Norregaard Construct' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 45 LOT 18 BLK 1 PIRATES BEACH SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6319' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '358' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Pirates Beach Sec 8' ,`TaxAmount` = '824' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1669056992' WHERE `Matrix_Unique_ID` = '214616407' --> 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','214663122','1669056992','214663122','2022-11-20T21:17:41.077','10007174','Ken Manee','EOC Realty Associates LLC','','','29.583587','-95.221815','23','77089','7','299950.00','Active','Sagevale','11511','Lane','Houston','2','0','3','2040','Single-Family','Updated home inside and out! Never flooded! Great curb appeal with freshly painted exterior featuring stained wood accents. Dusk to dawn exterior lighting around perimeter of house under the eaves. Walk into the spacious living area with vaulted wood plank ceiling, wood-look porcelain tile floors, floor to ceiling stacked brick fireplace wall. Kitchen open to living area has 2 breakfast bars, granite counters, white cabinets, updated hardware and KitchenAid stainless appliances with double ovens. Sunny breakfast room has large windows. Formal dining/study with double French doors. All bedrooms have walk-in closets plus a large storage closet in hall. Both baths have double sinks and are updated with fixtures, hardware, tile, white soft-close cabinets and seamless glass shower door in primary bath. Fresh decorator paint throughout with updated wide baseboards, interior doors, knobs, ceiling fans and recessed LED lighting. Clear Creek schools. Subdivision pool and tennis courts.','0.1931','3','Perry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','1','Southbelt/Ellington','Central Gas','1','LT 5 BLK 11 SAGEGLEN SEC 1 R/P','Cleared,Subdivision Lot','8410','Appraisal District','','265','0','','1','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','9 - Clear Creek','WEBER ELEMENTARY','CLEAR BROOK HIGH SCHOOL','WESTBROOK INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Sageglen','4801','2.356','Public Sewer,Public Water,Water District','1977','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T21:36:48.050' ,`MLSNumber` = '73192182' ,`ListAgentFullName` = 'Elridge Guillory' ,`ListOfficeName` = 'Quest Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.584970' ,`Longitude` = '-95.522162' ,`PhotoCount` = '31' ,`PostalCode` = '77489' ,`RoomCount` = '4' ,`ListPrice` = '324990.00' ,`Status` = 'Active' ,`StreetName` = 'Green Hollow' ,`StreetNumber` = '2826' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2883' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and View this Beautiful Spacious 4Bed, 3.5bath 2-Story Home Nestled on a CUL-DE-SAC lot! New Paint, New Carpet, New Granite Countertops! Downstairs features your Primary Bedroom, Family Room, and both Formals! Upstairs feature the Gameroom and 3 more spacious rooms! Large backyard for family gatherings and cookouts! Call for an appointment, won’t last long!' ,`Acres` = '0.152' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'QUAIL GREEN SEC 2, BLOCK 6, LOT 33' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6619' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'EDGAR GLOVER JR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Quail Green Sec 2' ,`TaxAmount` = '6244' ,`TaxRate` = '3.1174' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056992' WHERE `Matrix_Unique_ID` = '214691491' --> 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','214794428','1669056992','214794428','2022-11-20T21:38:23.380','57189388','Bradley Sanders','Fast Homes','','','29.873586','-95.434818','4','77088','3','330000.00','Active','Virgil','8021','Street','Houston','2','1','3','1804','Single-Family','Coming soon...New Construction! Beautifully designed modern 2 story home!','0.0647','11','Corporate Investment','','Electric Dryer Connections','','No Disclosures','','','','Northwest Houston','Central Electric','0','LT 44 BLK 10 HIGHLAND AMEND','Subdivision Lot','2820','Appraisal District','','','1','To Be Built/Under Construction','2','Electric Oven','0','','','Electric Range','','Composition','1 - Aldine','ANDERSON ACADEMY','CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS','DREW ACADEMY','Appointment Required,Leave Business Card,Supra Keybox','Appraisal','2','Contemporary/Modern','Highland Heights','428','2.5119','Public Sewer','2022','Appraisal'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T22:37:05.443' ,`MLSNumber` = '84865923' ,`ListAgentFullName` = 'Melissa McHargue' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810747' ,`Longitude` = '-94.811088' ,`PhotoCount` = '25' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Maley' ,`StreetNumber` = '1115' ,`StreetSuffix` = 'Road' ,`City` = 'Cove' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1861' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bring your boat! This captivating 4-bedroom, 3-bathroom split-level ranch is enviably located in Cove, TX where children commonly attend Barbers Hill ISD schools. Exterior features include a salt water pool, surrounded by a spacious concrete deck. The lush park-like grounds with breezy front & back porches contribute to the recreational feel. Cross the front entry threshold into the living room where neutral decor & gas fireplace provide a warm welcome. Stylish kitchen combines granite counters & practical functionality in an efficient layout . Beyond simply restful, one primary bedroom suite includes a walk-in closet, linen closet, private bath with step-in shower. The other 3 bedrooms, including a second primary suite, are quiet, & rich with ample wardrobe storage. There is a detached garage/workshop in addition to a well house with an adjoining storage room. This home is conveniently located near shopping and dining options and the Hugo boat ramp.' ,`Acres` = '1.3306' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric,Other Heating,Propane' ,`HOAMandatory` = '0' ,`Legal` = '306 TR 50B-0 ABJ WINFREE' ,`LotDesciption` = 'Other' ,`LotSize` = '57961' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Split Level' ,`Subdivision` = 'none' ,`TaxAmount` = '3184' ,`TaxRate` = '1.656' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056992' WHERE `Matrix_Unique_ID` = '214936163' --> 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','214959831','1669056992','214959831','2022-11-20T21:43:41.250','43061769','Gayla Gayden','REALM Real Estate Professional','','','29.736102','-95.915198','28','77441','10','271990.00','Active','Whittis Hill Way','31715','','Fulshear','2','0','3','1297','Single-Family','The Abbot Floor Plan by D.R. Horton! Completed & Move In Ready! Wonderful Covered Back Patio! Farmhouse Style Elevation! Grand Entering with High Ceilings & Gorgeous Vinyl Wood Flooring throughout the Main Living Areas! Family & Casual Dining Area is open to the Dramatic Gourmet Kitchen W/Tall Gray Shaker Cabinets, Beautiful Granite Counters, Large Eat-in Working Island W/Deep Under-mount Stainless Sink, Dupure Water Filtration System & Whirlpool Stainless Appliances! Amazing Huge Family Room! The Private Owners Suite features a Luxurious Bathroom W/His & Her Undermount Sinks Shaker Cabinets Vanity W/Granite, Large Tile Floors, Massive Seamless Glass Shower W/Tile Surroundings & Walk-in Closet! Guest Bedrooms private & tucked away! Energy Saving-HERS Energy Rated, Tankless/On-Demand H2O Heater &\"Smart Home System which allows you to control the Skybell, Locks, Lighting, Thermostat, Wireless Security & control anywhere! NO FLOODING ! Amenities include: Pool, Splash Pad, Lakes & More!','','30','D.R. Horton','','Electric Dryer Connections,Washer Connections','','Mud,No Disclosures','1','','','Fulshear/South Brookshire/Simonton','Central Gas','1','lot 38 block 4','Subdivision Lot','','Unknown','','1250','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','33 - Lamar Consolidated','TAMARRON ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','No Appointment Required,No Supra Keybox,Vacant/Unoccupied','Builder','1','Contemporary/Modern,Ranch','Tamarron','','2.96','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214959897','1669056992','214959897','2022-11-20T22:27:53.347','43416601','Jianyun Qin','HomeSmart','','','30.018352','-95.759341','33','77433','12','538000.00','Active','Winter Violet','21614','Court','Cypress','3','1','4','3617','Single-Family','Beautiful upgraded home situated in master planned community of Fairfield Lake Point neighborhood. Prime Location! Close to pool, school and Fairfield Athletic Center. Home offers high ceiling and open floor plan. SS appliances and gas cooktop. Custom built private heated pool with hot tub. Covered car port with entry door directly to kitchen. Designer paint. Wood Floor in Master suite. Tile in rest of first floor and wet area. Beautiful Upgraded crystal chandelier lighting throughout. Room sizes 3617 from appraisal district. 3824 from past appraisal report. Make appointments today!','','35','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','1','Cypress North','Central Gas,Zoned','1','LT 17 BLK 3 FAIRFIELD VILLAGE NORTH SEC 4','Cul-De-Sac,Subdivision Lot','8892','Appraisal District','','970','0','','2','Convection Oven,Electric Oven','1','Gunite,Heated,In Ground','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','SWENKE ELEMENTARY SCHOOL','BRIDGELAND HIGH SCHOOL','SALYARDS MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Fairfield Village North','','2.611','Water District','2006','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214960098','1669056992','214960098','2022-11-20T22:03:35.427','35825155','Nina Patel','RE/MAX Fine Properties','','','29.570145','-95.520585','24','77459','6','371990.00','Active','Harper Meadow','3418','Lane','Missouri City','3','0','5','2607','Single-Family','<5 BEDROOMS w/STUDY ONE STORY HOME > WOW. DR Horton\'s popular IRVING Plan (L) is spacious with 2607 Sq ft with additional features including a formal dining, open concept kitchen and living space, oversized covered patio & 2 car garage! Ultra-modern designs, 4 sides brick, tankless water heater, smart home, prewires and switch for future pendant lights over kitchen island, luxury vinyl plank, 42-inch white cabinets, grey quartz countertops in kitchen, white in bathrooms, extended shower in the primary, ss appliances, full sod front and back, 16 Seer AC, 1/2/10 warranty. Park\'s Edge is a 300-acre master-planned community with over 6 miles of walking trails with a pedestrian bridge connecting to Missouri City\'s Park & Rec Center to enjoy year-round activities. Parks Edge offers resort-style amenities-waterpark, a pool, a playground & sports field. Plus, easy commute to downtown, Galleria & Pearland w/ nearby Fort Bend Tollroad. Stop by the model today!','','38','D.R. Horton, Inc.','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Missouri City Area','Central Gas','1','Parks Edge Lot 5 Block 2 Section 11','Subdivision Lot','8125','Other','','900','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','PALMER ELEMENTARY SCHOOL (FORT BEND)','HIGHTOWER HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','Appointment Required','Builder','1','Contemporary/Modern,Ranch','Parks Edge','','3.24','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214960224','1669056992','214960224','2022-11-20T22:02:48.160','85734395','Nina Patel','RE/MAX Fine Properties','','','29.567846','-95.520603','24','77459','6','374990.00','Active','Park Crest','1323','Drive','Missouri City','3','0','5','2607','Single-Family','<5 BEDROOMS w/STUDY ONE STORY HOME > WOW. DR Horton\'s popular IRVING Plan (L) is spacious with 2607 Sq ft with additional features including a formal dining, open concept kitchen and living space, oversized covered patio & 2 car garage! Ultra-modern designs, 4 sides brick, tankless water heater, smart home, prewires and switch for future pendant lights over kitchen island, luxury vinyl plank, 42-inch grey cabinets, white quartz countertops in kitchen, white in bathrooms, garden tub and shower in the primary, ss appliances, gas line in patio, full sod front and back, 16 Seer AC, 1/2/10 warranty. Park\'s Edge is a 300-acre master-planned community with over 6 miles of walking trails with a pedestrian bridge connecting to Missouri City\'s Park & Rec Center to enjoy year-round activities. Parks Edge offers resort-style amenities-waterpark, a pool, a playground & sports field. Plus, easy commute to downtown, Galleria & Pearland w/ nearby Fort Bend Tollroad. Stop by the model today!','','38','D.R. Horton, Inc.','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Missouri City Area','Central Gas','1','Parks Edge Lot 9 Block 1 Section 11','Subdivision Lot','7500','Other','','900','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','PALMER ELEMENTARY SCHOOL (FORT BEND)','HIGHTOWER HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','Appointment Required','Builder','1','Contemporary/Modern,Ranch','Parks Edge','','3.24','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214960405','1669056992','214960405','2022-11-20T22:02:02.937','44147175','Nina Patel','RE/MAX Fine Properties','','','29.569759','-95.515881','24','77459','6','377990.00','Active','Balboa Grove','3311','Lane','Missouri City','3','0','5','2607','Single-Family','<<5 BEDROOMS w/STUDY ONE STORY HOME >> WOW. DR Horton\'s popular IRVING Plan (N) is spacious with 2607 Sq ft with additional features including a formal dining, open concept kitchen and living space, oversized covered patio & 2 car garage! Ultra-modern designs, 4 sides brick, tankless water heater, smart home, prewires and switch for future pendant lights over kitchen island, luxury vinyl plank, 42-inch white cabinets, grey quartz countertops in kitchen, white in bathrooms, extended shower in the primary, ss appliances, full sod front and back, gas line in patio, sprinklers,16 Seer AC, 1/2/10 warranty. Park\'s Edge is a 300-acre master-planned community with over 6 miles of walking trails with a pedestrian bridge connecting to Missouri City\'s Park & Rec Center to enjoy year-round activities. Parks Edge offers resort-style amenities-waterpark, a pool, a playground & sports field. Plus, easy commute to downtown, Galleria & Pearland w/ nearby Fort Bend Tollroad. Stop by the model today!','','38','D.R. Horton, Inc.','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Missouri City Area','Central Gas','1','Parks Edge Lot 5 Block 4 Section 19','Subdivision Lot','7800','Other','','900','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','PALMER ELEMENTARY SCHOOL (FORT BEND)','HIGHTOWER HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','Appointment Required','Builder','1','Contemporary/Modern,Ranch','Parks Edge','','3.24','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214966452','1669056992','214966452','2022-11-20T21:41:07.720','88988449','Javiela Delao','Doug Erdy Group','','','29.776073','-94.998449','20','77521','5','225000.00','Active','Shelldrake','3204','Way','Baytown','2','1','4','1425','Single-Family','Welcome to 3204 Sheldrake way in Baytown, this beautiful 2 story home features 4 bedrooms, 2.5 bathrooms , a large family broom with a fireplace a good size fenced backyard . It’s a perfect place to call home. \r\nSchedule your tour today this one won’t last long !!!!','0.1733','2','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','1','Baytown/Harris County','Central Gas','0','LT 251 QUAIL HOLLOW SEC 2 R/P','Subdivision Lot','7551','Appraisal District','','','0','','2','','0','','','','','Composition','23 - Goose Creek Consolidated','HARLEM ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','GENTRY JUNIOR HIGH SCHOOL','Leave Business Card','Appraisal District','2','Traditional','Quail Hollow','4877','2.97','Public Sewer,Public Water,Water District','1978','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214986377','1669056993','214986377','2022-11-20T21:07:00.730','55517864','Brandon Wilson','NB Elite Realty','','','29.461297','-95.068662','1','77539','1','99000.00','Active','Deats','1510','Road','Dickinson','1','0','1','956','Single-Family','CASH ONLY there are two homes on a single lot. One is distressed and gutted needing a complete rehab. The second home is a 1 bed 1 bath and is currently occupied by a tenant. Everything is as is and cash only deal.','0.2865','33','','','','','No Disclosures,Owner/Agent','','','','Dickinson','No Heating','0','ABST 19 PERRY & AUSTIN SUR LOT 2 PAUL LOBITS SUB','Cleared','12480','Appraisal District','','','0','','','','0','','','','','Composition','17 - Dickinson','CALDER ROAD ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Temporarily No Showings','Appraisal District','1','Traditional','Lobit Paul Lt 109','1685','2.5214','Public Sewer,Public Water','1974','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','214986450','1669056993','214986450','2022-11-20T21:20:47.633','70812091','Tania Castelan','Connect Realty','','','29.997566','-94.225046','39','77713','5','475000.00','Active','Kidd','7638','Road','Beaumont','3','1','5','3621','Single-Family','Gorgeous brick home sitting on 2 acres of land waiting for it\'s new owner! Walk in to be greeted w/ an open floorplan, concrete stained floors, crown molding, recessed lighting & more! Off to the right you have a formal dining area currently being used as a sitting room. The living area boasts double French doors leading out to the back patio, allowing for an abundance of natural light to flow into the main area. The kitchen features granite countertops, a large island, built-in oven and tons of cabinet space for all your storage. Retreat to the large master suite where you\'ll find double sinks, a jetted tub, separate shower & a walk-in closet. You have 2 guest bedrooms downstairs w/ a full bath & half bath. Upstairs are 2 more guest bedrooms w/ a full bath as well. Sit out on your back patio & enjoy the Texas sunsets w/ no back neighbors, just land! Call today to schedule your personal tour!','2','51','','','','','Sellers Disclosure','1','','','','Central Electric','0','H T & B RR-ABS 146 TR 38 2.000 SO PARK','Cleared,Subdivision Lot','87120','Appraisal District','','','0','','3','Electric Oven','0','','','Electric Cooktop','','Composition','143 - Beaumont','DISHMAN ELEMENTARY SCHOOL (BEAUMONT)','WEST BROOK HIGH SCHOOL','VINCENT MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','OTHER','4601','1.8901','Septic Tank','2010','Appraisal District'); --> New record created successfully